Missing closing ]
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
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