Horton

Re: Can't find the right generated column syntax

David G. Johnston <david.g.johnston@gmail.com>

View thread View on postgr.es
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Bzzzz <lazyvirus@gmx.com>
Cc: pgsql-novice <pgsql-novice@postgresql.org>
Date: 2019-11-26T03:35:50Z
Lists: 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.