Postgres Pro
Downloads
Home   >   mailing lists

Re: "reverse" (?) UPSERT -- how to ? - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: "reverse" (?) UPSERT -- how to ?
Date
Msg-id ZdD7DMe_vb0FCOcn@hermes.hilbert.loc
Whole thread Raw
In response to Re: "reverse" (?) UPSERT -- how to ?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Tree view 
Am Sat, Feb 17, 2024 at 07:25:11PM +0100 schrieb Karsten Hilbert:

> +1  except that I've got use for both parts of the UNION on
> their own (they are both views themselves involving a bunch
> of joins with yet other tables, 4 or 5 each or so ;-)

Just for kicks, attached find the SQL change script ...

Using a LEFT JOIN would get unwieldy, fast, I guess.

Karsten
--
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B
Attachment

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: "reverse" (?) UPSERT -- how to ?
Next
From: Kerr Livingstone
Date:
Subject: Re: Version 6 binaries for RHEL 7