Re: BUG #18195: PL/pgSQL: invalid syntax allowed in SELECT INTO statement

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: BUG #18195: PL/pgSQL: invalid syntax allowed in SELECT INTO statement
Дата
Msg-id CAFj8pRAQCb+WsPuh9EYgY0F-p=o+7b1oA0Uubi4L=darg-SbZQ@mail.gmail.com
обсуждение исходный текст
Ответ на RE: BUG #18195: PL/pgSQL: invalid syntax allowed in SELECT INTO statement  ("Pavel Kulakov" <paul.kulakov@systematica.ru>)
Список pgsql-bugs
Дерево обсуждения


st 15. 11. 2023 v 8:47 odesílatel Pavel Kulakov <paul.kulakov@systematica.ru> napsal:
This also permits the following syntax in PL/pgSQL:

do $sql$
declare _s text;
begin
   _s = '1' somegarbage;
end;
$sql$;

I understand why it works. But it looks really strange.

yes, it is strange, but PL/pgSQL is a translator from PL/pgSQL to SQL, and '1 xxx' is the correct expression in SQL. Probably today, where PL/pgSQL assign statements are supported in SQL parser the better design can be implemented. But probably it should still be hard for SELECT INTO.

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

Предыдущее
От: "Pavel Kulakov"
Дата:
Сообщение: RE: BUG #18195: PL/pgSQL: invalid syntax allowed in SELECT INTO statement
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #18196: Databases Created in Turkish Language Will Not Run on the Latest Version of Windows