Re: "reverse" (?) UPSERT -- how to ?

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: Rob Sargent <robjsargent(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: "reverse" (?) UPSERT -- how to ?
Date: 2024-02-17 18:22:53
Message-ID: ZdD5fVluz_t2_fyk@hermes.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2024-02-17 18:25:08 Re: Version 6 binaries for RHEL 7
Previous Message Karsten Hilbert 2024-02-17 18:20:56 Re: "reverse" (?) UPSERT -- how to ?