Re: BUG #17272: Incorrect syntax parsed - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #17272: Incorrect syntax parsed
Date
Msg-id 412653.1636120165@sss.pgh.pa.us
Whole thread Raw
In response to BUG #17272: Incorrect syntax parsed  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> Formally, the INTO should always precede the FROM keyword in a SELECT INTO
> statement. ( https://www.postgresql.org/docs/12/sql-selectinto.html )

That is not the appropriate reference for plpgsql's version of
SELECT INTO.  You should be reading

https://www.postgresql.org/docs/12/plpgsql-statements.html#PLPGSQL-STATEMENTS-SQL-ONEROW

which explains plpgsql's rules for where to put INTO.

            regards, tom lane



pgsql-bugs by date:

Previous
From: Matthias van de Meent
Date:
Subject: Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune()
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #17235: PQsendQuery (with two sql) after PQenterPipelineMode cause ERROR