Horton

Re: FOR PORTION OF should not allow WHERE CURRENT OF

Peter Eisentraut <peter@eisentraut.org>

View thread View on postgr.es
From: Peter Eisentraut <peter@eisentraut.org>
To: Paul A Jungwirth <pj@illuminatedcomputing.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-06-29T13:27:18Z
Lists: pgsql-hackers 
On 17.06.26 07:10, Paul A Jungwirth wrote:
> I found a bug with FOR PORTION OF: you shouldn't be able to provide it
> while using WHERE CURRENT OF with a cursor, but you can. (And it
> doesn't do anything sensible.)
> 
> According to the SQL standard, combining these is not allowed: you can
> give FOR PORTION OF with an <update/delete statement: searched> but
> not an <update/delete statement: positioned>. I've attached a patch to
> raise an error if you try to use both.

committed

Commits

  1. Forbid FOR PORTION OF with WHERE CURRENT OF