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.
