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

From Thomas Kellerer
Subject Re: How to write such a query
Date
Msg-id de9a6288-72a3-3638-ecc2-672d274de717@gmx.net
Whole thread Raw
In response to Re: How to write such a query  (Igor Korot <ikorot01@gmail.com>)
List pgsql-general
Igor Korot schrieb am 18.09.2020 um 22:18:
> Thank you for the info.
> My problem is that I want to emulate Access behavior.
>
> As I said - Access does it without changing the query internally (I presume).
>
> I want to do the same with PostgreSQL.
>
> I'm just trying to understand how to make it work for any query
>
> I can have 3,4,5 tables, query them and then update the Nth record in the resulting recordset.
>
> Access does it, PowerBuilder does it.

I assume that they query the database to find the primary key for the table in question.
Once the primary key columns are known (and part of the result), they generate the appropriate
UPDATE statement with a WHERE clause based on the the values in the result to update
the row that was changed.

Thomas



pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: How to write such a query
Next
From: Ron
Date:
Subject: Re: How to write such a query