On Mon, Nov 17, 2025 at 8:34 AM PG Doc comments form <[email protected]> wrote: > It looks to me as if there is an error in the sample associated with > documentation on date ranges on page: > https://www.postgresql.org/docs/current/rangetypes.html > If you scroll to the last few examples on the page, the values inserted are > in [) brackets rather than [] brackets.
Do you mean the room_reservation table? A tsrange uses [) syntax, signifying closed/open endpoints. So it includes the start time but not the end time. This is the most common way to use ranges, since it lets adjacent ranges "lock together" without any overlap. You can input tsranges with whatever endpoints you like, but they will use [) syntax when they draw themselves. You can define new range types with different behavior though. See https://www.postgresql.org/docs/18/rangetypes.html#RANGETYPES-DISCRETE Yours, -- Paul ~{:-) [email protected]
