Postgres Pro
Downloads
Home   >   mailing lists

Can't find the right generated column syntax - Mailing list pgsql-novice

From Bzzzz
Subject Can't find the right generated column syntax
Date
Msg-id 20191126033041.3869adb5@msi.defcon1.lan
Whole thread Raw
Responses Re: Can't find the right generated column syntax
Re: Can't find the right generated column syntax
List pgsql-novice
Tree view 
Hi list,

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 ?)

Jean-Yves

pgsql-novice by date:

Previous
From: "Vianello, Dan A"
Date:
Subject: RE: Why oh why is this join not working?
Next
From: "David G. Johnston"
Date:
Subject: Re: Can't find the right generated column syntax