On Monday, November 25, 2019, David G. Johnston <
david.g.johnston@gmail.com> wrote:
On Monday, November 25, 2019, Bzzzz <lazyvirus@gmx.com> wrote:
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.
Nevermind this one - getting the quoting correct with a literal input expression is why using the function is much easier. Even swapping ) for ( isn’t enough though its close - just need to get a and b to be treated as column references.
David J.