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

Поиск
Список
Период
Сортировка
От David Fetter
Тема Re: V0.2 patch for TODO Item: SQL-language reference parameters by name.
Дата
Msg-id 20071103171548.GK3913@fetter.org
обсуждение исходный текст
Ответ на Re: V0.2 patch for TODO Item: SQL-language reference parameters by name.  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: V0.2 patch for TODO Item: SQL-language referenceparameters by name.  (Gregory Stark <stark@enterprisedb.com>)
Re: V0.2 patch for TODO Item: SQL-language reference parameters by name.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Gevik Babakhani"
Дата:
Сообщение: Re: V0.2 patch for TODO Item: SQL-language referenceparameters by name.
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: V0.2 patch for TODO Item: SQL-language referenceparameters by name.