pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17279: 'return query update ... returning *' reports syntax error in pg/plsql function
2+ messages / 2 participants
[nested] [flat]
* BUG #17279: 'return query update ... returning *' reports syntax error in pg/plsql function
@ 2021-11-10 12:55 PG Bug reporting form <noreply@postgresql.org>
2021-11-10 14:35 ` Re: BUG #17279: 'return query update ... returning *' reports syntax error in pg/plsql function Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2021-11-10 12:55 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: sify21@163.com
The following bug has been logged on the website:
Bug reference: 17279
Logged by: 'return query update ... returning *' reports syntax error
Email address: sify21@163.com
PostgreSQL version: 14.0
Operating system: Debian GNU/Linux 10 (buster)
Description:
In version 13, I can use 'return query update ... returning *;' to append to
the result set of pg/plsql functions, but now in version 14 it reports
syntax error : 'query is not a SELECT'(code 42601)
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #17279: 'return query update ... returning *' reports syntax error in pg/plsql function
2021-11-10 12:55 BUG #17279: 'return query update ... returning *' reports syntax error in pg/plsql function PG Bug reporting form <noreply@postgresql.org>
@ 2021-11-10 14:35 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2021-11-10 14:35 UTC (permalink / raw)
To: sify21@163.com; +Cc: pgsql-bugs@lists.postgresql.org
PG Bug reporting form <noreply@postgresql.org> writes:
> In version 13, I can use 'return query update ... returning *;' to append to
> the result set of pg/plsql functions, but now in version 14 it reports
> syntax error : 'query is not a SELECT'(code 42601)
This is fixed in 14.1, due out tomorrow.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2021-11-10 14:35 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-11-10 12:55 BUG #17279: 'return query update ... returning *' reports syntax error in pg/plsql function PG Bug reporting form <noreply@postgresql.org>
2021-11-10 14:35 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox