BUG #17279: 'return query update ... returning *' reports syntax error in pg/plsql function
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)
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