Re: SQL statement PREPARE does not work in ECPG

Поиск
Список
Период
Сортировка
От Michael Meskes
Тема Re: SQL statement PREPARE does not work in ECPG
Дата
Msg-id 68e1dd6c44149c05a71b26dbe2f3d0d2d4582028.camel@postgresql.org
обсуждение исходный текст
Ответ на RE: SQL statement PREPARE does not work in ECPG  ("Matsumura, Ryo" <matsumura.ryo@jp.fujitsu.com>)
Ответы RE: SQL statement PREPARE does not work in ECPG  ("Matsumura, Ryo" <matsumura.ryo@jp.fujitsu.com>)
Список pgsql-hackers
Hi Matsumura-san,

> I defined the following specifications. Please review it.
> 
> * ECPG can accept any valid PREPARE AS statement.
> * A char-type host variable can be used as the statement name of
> PREPARE AS,
>   but its value is constrained by the specification of PREPARE AS.
>   (e.g. the name cannot include double quotation.)
> * The above also allows the following. It's a bit strange but there
> is no reason
>   for forbidding.
>     prepare :st(type_list) as select $1
> * ECPG can accept EXECUTE statement with expression list that is
> allocated
>   by both PREPARE FROM and PREPARE AS under the following
> constraints:
>   - It must not include a using-clause.
>   - The statement name must follow to the specification of PREPARE
> AS.

This look very reasonable to me. I'm completely fine with this
restriction being placed on PREPARE FROM.

Michael
-- 
Michael Meskes
Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
Meskes at (Debian|Postgresql) dot Org
Jabber: michael at xmpp dot meskes dot org
VfL Borussia! Força Barça! SF 49ers! Use Debian GNU/Linux, PostgreSQL




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: reindexdb & clusterdb broken against pre-7.3 servers
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: reindexdb & clusterdb broken against pre-7.3 servers