Re: Can't find the right generated column syntax
| От | David G. Johnston |
|---|---|
| Тема | Re: Can't find the right generated column syntax |
| Дата | |
| Msg-id | CAKFQuwbUVHmYyCfkvzUwwcnod-dbbJEai0dg7vcEUDy8OR7H8g@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: 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:
CREATE TABLE tst_timerange(a timestamptz, b timestamptz, c tstzrange
generated always as ( SELECT tstzrange(a, b, '[)' ) ) stored); ERROR:
syntax error at or near "SELECT" LINE 1: ... b timestamptz, c tstzrange
generated always as ( SELECT tst...
Correct, i think, you recognized that removing select is what the error was telling you.
CREATE TABLE tst_timerange(a timestamptz, b timestamptz, c tstzrange
generated always as ( ('[a,b(') ) stored); ERROR: malformed range
literal: "[a,b(" LINE 1: ...b timestamptz, c tstzrange generated always
as ( ('[a,b(') )...
Also probably correct if you recognize that [( doesn’t make sense as a range boundary specification.
David J.
В списке pgsql-novice по дате отправления: