Re: Can't find the right generated column syntax

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.