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

From Pavel Stehule
Subject Re: Missing semicolumn in anonymous plpgsql block does not raise syntax error
Date
Msg-id CAFj8pRBWPVU9yMCAcb24pGNrdP3YCwbUjy3pnZtn2zWqqdkrRw@mail.gmail.com
Whole thread Raw
In response to Re: Missing semicolumn in anonymous plpgsql block does not raise syntax error  (Mor Lehr <mor.lehr@deel.com>)
List pgsql-bugs
Hi

ne 2. 6. 2024 v 18:25 odesílatel Mor Lehr <mor.lehr@deel.com> napsal:
Thanks for the reference.
We learn new stuff every day.

You can close the case.
Thanks, Mor


plpgsql_check can now detect this issue


Regards

Pavel


On Sun, Jun 2, 2024, 18:31 David G. Johnston <david.g.johnston@gmail.com> wrote:
On Sunday, June 2, 2024, Mor Lehr <mor.lehr@deel.com> wrote:
Thanks for the prompt reply.
Can you please refer me to the section in the documentation that describes this behavior?
This (automatically interperting 1 as select 1) is totally an unexpected behavior for me.


“As explained previously, the expression in such a statement is evaluated by means of an SQL SELECT command sent to the main database engine.”

David J.

pgsql-bugs by date:

Previous
From: Chris BSomething
Date:
Subject: Re: Bug in psql
Next
From: Mor Lehr
Date:
Subject: Re: Missing semicolumn in anonymous plpgsql block does not raise syntax error