| From: | Thomas Kellerer <shammat(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: How to write such a query |
| Date: | 2020-09-18 20:26:18 |
| Message-ID: | de9a6288-72a3-3638-ecc2-672d274de717@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2020-09-18 20:26:23 | Re: How to write such a query |
| Previous Message | Igor Korot | 2020-09-18 20:18:27 | Re: How to write such a query |