Re: named parameters in SQL functions

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема Re: named parameters in SQL functions
Дата
Msg-id 1D6D5B84-4AB8-4738-A156-420DC241F5BC@kineticode.com
обсуждение исходный текст
Ответ на Re: named parameters in SQL functions  (Greg Stark <gsstark@mit.edu>)
Ответы Re: named parameters in SQL functions
Re: named parameters in SQL functions
Список pgsql-hackers
On Nov 15, 2009, at 11:21 AM, Greg Stark wrote:

> No, that's not the same.
> 
> The point is that $ is a perfectly valid SQL identifier character and
> $foo is a perfectly valid identifier. You can always quote any
> identifier (yes, after case smashing) so you would expect if $foo is a
> valid identifier then "$foo" would refer to the same identifier.
> You're introducing a meaning for $foo but saying there's no valid way
> to quote the identifier to get the same thing. And worse, if you do
> quote it you get something else entirely different.

$foo should be killed off as a valid identifier, IMNSHO.

But failing that, some other sigil would be most welcome.

Best,

David


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: named parameters in SQL functions
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Summary and Plan for Hot Standby