Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Can't find the right generated column syntax
Date
Msg-id CAKFQuwbJtPX4ZBACxCD=b61B2ykG7UT-evFfJcwJW_PVYnpC3Q@mail.gmail.com
Whole thread Raw
In response to Can't find the right generated column syntax  (Bzzzz <lazyvirus@gmx.com>)
Responses Re: Can't find the right generated column syntax
List pgsql-novice
Tree view
On Monday, November 25, 2019, Bzzzz <lazyvirus@gmx.com> wrote:
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 ?)


You should provide actual SQL without typos and also show which version your are using.  Provide the error your are getting as well.

Also:


David J.
 

pgsql-novice by date:

Previous
From: Bzzzz
Date:
Subject: Can't find the right generated column syntax
Next
From: Bzzzz
Date:
Subject: Re: Can't find the right generated column syntax