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

Поиск
Список
Период
Сортировка
От Karsten Hilbert
Тема Re: "reverse" (?) UPSERT -- how to ?
Дата
Msg-id ZdD5fVluz_t2_fyk@hermes.hilbert.loc
обсуждение исходный текст
Ответ на Re: "reverse" (?) UPSERT -- how to ?  (Rob Sargent <robjsargent@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Karsten Hilbert
Дата:
Сообщение: Re: "reverse" (?) UPSERT -- how to ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Version 6 binaries for RHEL 7