Re: V0.2 patch for TODO Item: SQL-language reference parameters by name.

On Sat, Nov 03, 2007 at 12:44:07PM -0400, Tom Lane wrote:
> David Fetter <david@fetter.org> writes:
> > I think a prefix of ':' would be good, as it's already a standard,
> > kinda.  Anybody who names a database object :foo deserves whatever
> > happens to them :P
>
> The important word there is "kinda".  We do not need a prefix and
> I'll resist introducing one.

What I mean by "kinda" is that it's a standard way of handling
parameters in Oracle and in DBI.  I think it would be a very bad idea
to require that people use the function name in parameters, as such
names can be quite long.  People using names like :foo for database
objects could just quote them :)

Another possibility would be to introduce another parameter type in
addition to IN, OUT and INOUT called PREFIX (required to be of type
text) which would enable people to change from the default prefix.

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate