Re: BUG #17272: Incorrect syntax parsed

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: nagylzs(at)gmail(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17272: Incorrect syntax parsed
Date: 2021-11-05 13:49:25
Message-ID: 412653.1636120165@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2021-11-05 14:58:21 Re: BUG #17235: PQsendQuery (with two sql) after PQenterPipelineMode cause ERROR
Previous Message Matthias van de Meent 2021-11-05 11:43:00 Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune()