Horton

Can't find the right generated column syntax

Bzzzz <lazyvirus@gmx.com>

View thread View on postgr.es
From: Bzzzz <lazyvirus@gmx.com>
To: pgsql-novice <pgsql-novice@postgresql.org>
Date: 2019-11-26T02:30:41Z
Lists: pgsql-novice 
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