Horton

Re: Can't find the right generated column syntax

Laurenz Albe <laurenz.albe@cybertec.at>

View thread View on postgr.es
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Bzzzz <lazyvirus@gmx.com>, pgsql-novice <pgsql-novice@postgresql.org>
Date: 2019-11-26T07:10:19Z
Lists: pgsql-novice 
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