Postgres Pro
Downloads
Home   >   mailing lists

Re: Start with [ , end with ) - Mailing list pgsql-docs

From Mike Toews
Subject Re: Start with [ , end with )
Date
Msg-id CAM2FmMqvNbf_-hRJWLgtrxSf0kdEoRdwfCFVxx2gN2Kd=3+g6A@mail.gmail.com
Whole thread Raw
In response to Start with [ , end with )  (PG Doc comments form <noreply@postgresql.org>)
Responses Re: Start with [ , end with )  ("Jonathan S. Katz" <jkatz@postgresql.org>)
List pgsql-docs
Tree view 
On 24 April 2018 at 01:00, PG Doc comments form <noreply@postgresql.org> wrote:
> 8.17.2. Examples
>
> CREATE TABLE reservation (room int, during tsrange);
> INSERT INTO reservation VALUES
>     (1108, '[2010-01-01 14:30, 2010-01-01 15:30)');
>                ^                                                         ^
> While not an Error, still...

See 8.17.3. Inclusive and Exclusive Bounds

This is an example with an inclusive lower bound "[" and an exclusive
upper bound ")".

pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: why is there no CSVQL?
Next
From: "Jonathan S. Katz"
Date:
Subject: Re: Start with [ , end with )