Re: BUG #9001: Documentation bug - Mailing list pgsql-bugs

From bricklen
Subject Re: BUG #9001: Documentation bug
Date
Msg-id CAGrpgQ8=weF4nm76kdikPkR0n2X-91ov8xAUTmN8XUHJ_qEKkQ@mail.gmail.com
Whole thread Raw
In response to BUG #9001: Documentation bug  (kai.peters@gmail.com)
List pgsql-bugs
On Mon, Jan 27, 2014 at 8:38 AM, <kai.peters@gmail.com> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      9001
> Logged by:          Kai
> Email address:      kai.peters@gmail.com
> PostgreSQL version: 9.3.2
> Operating system:   Irrelevant
> Description:
>
> http://www.postgresql.org/docs/9.3/static/rangetypes.html
>
> 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)');
>
> Bracket/paren mismatch in above INSERT statement
>
>
You are referring to '[2010...)' ? No, that's by design. See the section
http://www.postgresql.org/docs/9.3/static/rangetypes.html#RANGETYPES-IO
Also, if you test the example you can see that it works as shown.

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #9003: Hard-coding to localhost in postmaster
Next
From: Tom Lane
Date:
Subject: Re: BUG #9003: Hard-coding to localhost in postmaster