public inbox for [email protected]
help / color / mirror / Atom feedTypo in range types documentation
2+ messages / 2 participants
[nested] [flat]
* Typo in range types documentation
@ 2025-11-17 13:13 PG Doc comments form <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2025-11-17 13:13 UTC (permalink / raw)
To: [email protected]; +Cc: [email protected]
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/18/rangetypes.html
Description:
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Typo in range types documentation
@ 2025-11-17 17:06 Paul A Jungwirth <[email protected]>
parent: PG Doc comments form <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Paul A Jungwirth @ 2025-11-17 17:06 UTC (permalink / raw)
To: [email protected]; [email protected]
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]
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-11-17 17:06 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-11-17 13:13 Typo in range types documentation PG Doc comments form <[email protected]>
2025-11-17 17:06 ` Paul A Jungwirth <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox