Postgres Pro
Downloads
Home   >   mailing lists

BUG #17279: 'return query update ... returning *' reports syntax error in pg/plsql function - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #17279: 'return query update ... returning *' reports syntax error in pg/plsql function
Date
Msg-id 17279-094b665e10bb29bd@postgresql.org
Whole thread Raw
Responses Re: BUG #17279: 'return query update ... returning *' reports syntax error in pg/plsql function
List pgsql-bugs
Tree view 
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)

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17278: Silent install issue
Next
From: PG Bug reporting form
Date:
Subject: BUG #17280: global-buffer-overflow on select from pg_stat_slru