Re: Controlling changes in plpgsql variable resolution

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Controlling changes in plpgsql variable resolution
Дата
Msg-id 20091019162916.GL17756@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: Controlling changes in plpgsql variable resolution  ("David E. Wheeler" <david@kineticode.com>)
Ответы Re: Controlling changes in plpgsql variable resolution
Список pgsql-hackers
* David E. Wheeler (david@kineticode.com) wrote:
> On Oct 19, 2009, at 8:36 AM, Robert Haas wrote:
>
>> I think warnings are too easy to miss, but I agree your other
>> suggestion.  I know you can write function_name.variable_name, but
>> that's often massively long-winded.  We either need a short, fixed
>> prefix, or some kind of sigil.  I previously suggested ? to parallel
>> ECPG, but Tom didn't like it.  I still do.  :-)
>
> I suppose that $ would interfere with dollar quoting. What about @ or @@
> (sorry, I did mess with MSSQL back in the 90s).

Uh, what dollar quoting?  $_$ is what I typically use, so I wouldn't
expect a $ prefix to cause a problem.  I think it'd be more of an issue
because pl/pgsql still uses $1 and whatnot internally (doesn't it?).
Stephen

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

Предыдущее
От: "David E. Wheeler"
Дата:
Сообщение: Re: Controlling changes in plpgsql variable resolution
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Rejecting weak passwords