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

From Karsten Hilbert
Subject Re: "reverse" (?) UPSERT -- how to ?
Date
Msg-id ZdD5fVluz_t2_fyk@hermes.hilbert.loc
Whole thread Raw
In response to Re: "reverse" (?) UPSERT -- how to ?  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
Am Sat, Feb 17, 2024 at 09:33:11AM -0700 schrieb Rob Sargent:

> > So, is this doable within one SQL statement (short of
> > creating and running the abovementioned function in
> > one go ;-) ?
> >
>
> Perhaps your pk_detail can be defined as generated always identity?

Rob, I'm sure there's something to be learned from that
suggestion the significance of which I don't grasp yet. Would
you mind expanding a bit ?

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



pgsql-general by date:

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