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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: sify21(at)163(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17279: 'return query update ... returning *' reports syntax error in pg/plsql function
Date: 2021-11-10 14:35:41
Message-ID: 1436769.1636554941@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)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

In response to

Browse pgsql-bugs by date

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