Обсуждение: Missing closing ]

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

Missing closing ]

От
PG Doc comments form
Дата:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/16/rangetypes.html
Description:

In the example session at
https://www.postgresql.org/docs/current/rangetypes.html#RANGETYPES-EXAMPLES
there are missing closing square bracket  ]

Take a look below
CREATE TABLE reservation (room int, during tsrange);
INSERT INTO reservation VALUES
    (1108, '[2010-01-01 14:30, 2010-01-01 15:30)');

there should be ] after 15:30

Re: Missing closing ]

От
Tom Lane
Дата:
PG Doc comments form <noreply@postgresql.org> writes:
> In the example session at
> https://www.postgresql.org/docs/current/rangetypes.html#RANGETYPES-EXAMPLES
> there are missing closing square bracket  ]

> Take a look below
> CREATE TABLE reservation (room int, during tsrange);
> INSERT INTO reservation VALUES
>     (1108, '[2010-01-01 14:30, 2010-01-01 15:30)');

> there should be ] after 15:30

No, it looks correct as given: that end of the range is open not closed.

            regards, tom lane