Re: How to write such a query

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Fri, Sep 18, 2020 at 1:18 PM Igor Korot <ikorot01@xxxxxxxxx> wrote:

As I said - Access does it without changing the query internally (I presume).

I want to do the same with PostgreSQL.

I suspect they basically do the equivalent of:

UPDATE ... WHERE CURRENT OF <cursor name>;

https://www.postgresql.org/docs/12/sql-update.html

David J.