Re: Can't find the right generated column syntax

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Can't find the right generated column syntax
Дата
Msg-id CAKFQuwbJtPX4ZBACxCD=b61B2ykG7UT-evFfJcwJW_PVYnpC3Q@mail.gmail.com
обсуждение исходный текст
Ответ на Can't find the right generated column syntax  (Bzzzz <lazyvirus@gmx.com>)
Ответы Re: Can't find the right generated column syntax
Список pgsql-novice
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 по дате отправления:

Предыдущее
От: Bzzzz
Дата:
Сообщение: Can't find the right generated column syntax
Следующее
От: Bzzzz
Дата:
Сообщение: Re: Can't find the right generated column syntax