Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: BUG #17279: 'return query update ... returning *' reports syntax error in pg/plsql function
Date
Msg-id 1436769.1636554941@sss.pgh.pa.us
Whole thread Raw
In response to BUG #17279: 'return query update ... returning *' reports syntax error in pg/plsql function  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17280: global-buffer-overflow on select from pg_stat_slru
Next
From: Andres Freund
Date:
Subject: Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum