named parameters in SQL functions

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема named parameters in SQL functions
Дата
Msg-id 4B003C58.5010305@dunslane.net
обсуждение исходный текст
Ответы Re: named parameters in SQL functions  (Andrew Chernow <ac@esilo.com>)
Re: named parameters in SQL functions  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: named parameters in SQL functions  (Robert Haas <robertmhaas@gmail.com>)
Re: named parameters in SQL functions  (Brendan Jurd <direvus@gmail.com>)
Re: named parameters in SQL functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: named parameters in SQL functions  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
At Tom's suggestion I am looking at allowing use of parameter names in 
SQL functions instead of requiring use of $1 etc. That raises the 
question of how we would disambiguate a parameter name from a column 
name. Essentially, ISTM, we could use some special marker such as @ 
(c.f. SQL Server) or : (c.f. ecpg) or else we could have some rule that 
says which name takes precedence. I think I prefer a special marker, 
other things being equal. Is there a standard on this?

cheers

andrew


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Summary and Plan for Hot Standby
Следующее
От: Andrew Chernow
Дата:
Сообщение: Re: named parameters in SQL functions