From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Gevik Babakhani <pgdev(at)xs4all(dot)nl>, pgsql-patches(at)postgresql(dot)org |
Subject: | Re: V0.2 patch for TODO Item: SQL-language reference parameters by name. |
Date: | 2007-11-03 17:15:48 |
Message-ID: | 20071103171548.GK3913@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
On Sat, Nov 03, 2007 at 12:44:07PM -0400, Tom Lane wrote:
> David Fetter <david(at)fetter(dot)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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2007-11-03 17:21:52 | Re: V0.2 patch for TODO Item: SQL-language referenceparameters by name. |
Previous Message | Gevik Babakhani | 2007-11-03 16:46:56 | Re: V0.2 patch for TODO Item: SQL-language referenceparameters by name. |