On Tue, 2019-11-26 at 03:30 +0100, Bzzzz wrote:
> I've got this table:
> date_start timestamptz,
> date_end temstamptz
>
> and I'd like to auto-generate a 3rd column with a tstzrange:
> date_start timestamptz,
> date_end temstamptz,
> duration tstzrange GENERATED ALWAYS AS ( ? ) STORED
>
> but I can't find the right syntax to do so :/ (is it even possible ?)
That should be as simple as
GENERATED ALWAYS AS (tstzrange(date_start, date_end)) STORED
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com