BUG #17279: 'return query update ... returning *' reports syntax error in pg/plsql function

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: sify21(at)163(dot)com
Subject: BUG #17279: 'return query update ... returning *' reports syntax error in pg/plsql function
Date: 2021-11-10 12:55:17
Message-ID: 17279-094b665e10bb29bd@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17279
Logged by: &#39;return query update ... returning *&#39; reports syntax error
Email address: sify21(at)163(dot)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)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2021-11-10 13:42:25 BUG #17280: global-buffer-overflow on select from pg_stat_slru
Previous Message PG Bug reporting form 2021-11-10 10:25:44 BUG #17278: Silent install issue