Re: [HACKERS] Is "query" a reserved word in 8.3 plpgsql?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Is "query" a reserved word in 8.3 plpgsql?
Дата
Msg-id 6089.1194653237@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Is "query" a reserved word in 8.3 plpgsql?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Ответы Re: [HACKERS] Is "query" a reserved word in 8.3 plpgsql?
Re: [HACKERS] Is "query" a reserved word in 8.3 plpgsql?
Список pgsql-general
"Scott Marlowe" <scott.marlowe@gmail.com> writes:
> On Nov 9, 2007 5:14 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> [ thinks for a bit... ]  It might be possible to get rid of the keyword
>> and have RETURN QUERY be recognized by an ad-hoc strcmp test, much like
>> the various direction keywords in FETCH have been handled without making
>> them real keywords.  It'd be a bit uglier but it'd avoid making QUERY
>> be effectively a reserved word.

> It's not uncommon to have auditing triggers store things in tables
> with fields named query in them.  I know I have a few places that do
> this...

It turned out to be a very easy change, so it's done: QUERY isn't a
reserved word anymore.

            regards, tom lane

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

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Is "query" a reserved word in 8.3 plpgsql?
Следующее
От: Rajarshi Guha
Дата:
Сообщение: looping over the rows in a table