Re: plpgsql variable named as SQL keyword

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: plpgsql variable named as SQL keyword
Дата
Msg-id 20354.1551378020@sss.pgh.pa.us
обсуждение исходный текст
Ответ на plpgsql variable named as SQL keyword  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: plpgsql variable named as SQL keyword  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
> Maybe we should to disallow variables named as sql reserved keyword.

That would just break existing code.  There are lots of other
examples where you can get away with such things.

We've expended quite a lot of sweat to avoid reserving more names than
we had to in plpgsql.  I'm disinclined to throw that away just because
somebody found an error message confusing.  It's not like reserving
"offset" would cause this case to work.

            regards, tom lane


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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] EvalPlanQual behaves oddly for FDW queries involvingsystem columns
Следующее
От: Mahendra Singh
Дата:
Сообщение: Re: Question about pg_upgrade from 9.2 to X.X