Re: [PATCH] Add UPDATE WHERE OFFSET IN clause

2022-02-07 Thread Tom Lane
Chapman Flack writes: > On 02/07/22 00:59, Böszörményi Zoltán wrote: >> UPDATE ... WHERE OFFSET n IN cursor; > If added to UPDATE, should this be added to DELETE also? FWIW, I think this is a really horrid hack. For one thing, it's not robust against not-strictly-linear FETCH/MOVE of the cursor

Re: [PATCH] Add UPDATE WHERE OFFSET IN clause

2022-02-07 Thread Chapman Flack
Hi! On 02/07/22 00:59, Böszörményi Zoltán wrote: > UPDATE ... WHERE OFFSET n IN cursor; If added to UPDATE, should this be added to DELETE also? Regards, -Chap