Re: Missing semicolumn in anonymous plpgsql block does not raise syntax error

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Missing semicolumn in anonymous plpgsql block does not raise syntax error
Дата
Msg-id 2365647.1717366731@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Missing semicolumn in anonymous plpgsql block does not raise syntax error  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Missing semicolumn in anonymous plpgsql block does not raise syntax error
Список pgsql-bugs
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> I think you just wrote the equivalent of:
> l_cnt := (select 1 as delete from foo3 where id=1);
> Which is a valid query.

Still another example of the folly of letting AS be optional.
I don't suppose we can ever undo that though.

            regards, tom lane



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

Предыдущее
От: Floris Van Nee
Дата:
Сообщение: RE: error "can only drop stats once" brings down database
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #18492: Adding a toasted column to a table with an inherited temp table fails with Assert