Re: Can't find the right generated column syntax

Laurenz Albe <[email protected]> Tue, 26 Nov 2019 08:10:19 +0100

Newsgroups	gmane.comp.db.postgresql.novice
Message-ID	<[email protected]>

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