Home > mailing lists

Re: How to write such a query - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: How to write such a query
Date	September 18, 2020 23:39:07
Msg-id	CAKFQuwYCcreak5NEMNNfoJXQTj64R3VO=mA43OjXcUYxdUEOYQ@mail.gmail.com Whole thread Raw
In response to	Re: How to write such a query (Igor Korot <ikorot01@gmail.com>)
List	pgsql-general

On Fri, Sep 18, 2020 at 1:18 PM Igor Korot <ikorot01@gmail.com> 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>;

David J.

From: Ken Tanzer
Date: 18 September 2020, 23:34:25
Subject: Re: How to write such a query

From: Igor Korot
Date: 19 September 2020, 01:09:38
Subject: Re: How to write such a query