Обсуждение: BUG #9001: Documentation bug

Поиск
Список
Период
Сортировка

BUG #9001: Documentation bug

От
kai.peters@gmail.com
Дата:
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

Re: BUG #9001: Documentation bug

От
bricklen
Дата:
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.