Re: [PATCHES] prepareable statements

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: nconway@klamath.dyndns.org (Neil Conway)
Cc: pgsql-hackers@postgreSQL.org
Date: 2002-07-23T15:34:39Z
Lists: pgsql-hackers
nconway@klamath.dyndns.org (Neil Conway) writes:
> Regarding the syntax for EXECUTE, it occurs to me that it could be made
> to be more similar to the PREPARE syntax -- i.e.

> PREPARE foo(text, int) AS ...;

> EXECUTE foo('a', 1);

> (rather than EXECUTE USING -- the effect being that prepared statements
> now look more like function calls on a syntactical level, which I think
> is okay.)

Hmm, maybe *too* much like a function call.  Is there any risk of a
conflict with syntax that we might want to use to invoke stored
procedures?  If not, this is fine with me.

			regards, tom lane