Re: named parameters in SQL functions

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: named parameters in SQL functions
Дата
Msg-id 162867790911151116o322d5844l8c4bb542424f69ad@mail.gmail.com
обсуждение исходный текст
Ответ на Re: named parameters in SQL functions  (Andrew Chernow <ac@esilo.com>)
Список pgsql-hackers
2009/11/15 Andrew Chernow <ac@esilo.com>:
>
>>> I like the special marker idea.  A '$' would be nice because its already
>>> in
>>> use for similar purposes, but I think that would lead to ambiguity with
>>> dollar quoting.
>>
>> no, it should be safe (if you don't use for dollar quoting some like
>> $variablename$)
>>
>
> Actually, I was thinking of something like $abc$def, where abc and def are
> variables.  Although, this is much less likely than column name conflicts.
>
> Other possibles are: $(var), @var@, or %var%.  I'd perfer a single character
> marker but that may not fly.
>

single character is my preference too.

Pavel
> --
> Andrew Chernow
> eSilo, LLC
> every bit counts
> http://www.esilo.com/
>


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

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