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

From David Fetter
Subject Re: V0.2 patch for TODO Item: SQL-language reference parameters by name.
Date
Msg-id 20071103171548.GK3913@fetter.org
Whole thread Raw
In response to Re: V0.2 patch for TODO Item: SQL-language reference parameters by name.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: V0.2 patch for TODO Item: SQL-language referenceparameters by name.
Re: V0.2 patch for TODO Item: SQL-language reference parameters by name.
List pgsql-patches
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

pgsql-patches by date:

Previous
From: "Gevik Babakhani"
Date:
Subject: Re: V0.2 patch for TODO Item: SQL-language referenceparameters by name.
Next
From: Gregory Stark
Date:
Subject: Re: V0.2 patch for TODO Item: SQL-language referenceparameters by name.