Postgres Pro
Downloads
Home   >   mailing lists

Re: Missing semicolumn in anonymous plpgsql block does not raise syntax error - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Missing semicolumn in anonymous plpgsql block does not raise syntax error
Date
Msg-id 2365647.1717366731@sss.pgh.pa.us
Whole thread Raw
In response to Re: Missing semicolumn in anonymous plpgsql block does not raise syntax error  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Missing semicolumn in anonymous plpgsql block does not raise syntax error
List pgsql-bugs
Tree view 
"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 by date:

Previous
From: Floris Van Nee
Date:
Subject: RE: error "can only drop stats once" brings down database
Next
From: PG Bug reporting form
Date:
Subject: BUG #18492: Adding a toasted column to a table with an inherited temp table fails with Assert