pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedStart with [ , end with )
3+ messages / 3 participants
[nested] [flat]
* Start with [ , end with )
@ 2018-04-23 13:00 PG Doc comments form <noreply@postgresql.org>
2018-04-24 03:37 ` Re: Start with [ , end with ) Mike Toews <mwtoews@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: PG Doc comments form @ 2018-04-23 13:00 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: yonatanhak@gmail.com
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/rangetypes.html
Description:
See in:
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)');
^ ^
While not an Error, still...
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Start with [ , end with )
2018-04-23 13:00 Start with [ , end with ) PG Doc comments form <noreply@postgresql.org>
@ 2018-04-24 03:37 ` Mike Toews <mwtoews@gmail.com>
2018-04-24 05:09 ` Re: Start with [ , end with ) Jonathan S. Katz <jkatz@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: Mike Toews @ 2018-04-24 03:37 UTC (permalink / raw)
To: yonatanhak@gmail.com; pgsql-docs@lists.postgresql.org
On 24 April 2018 at 01:00, PG Doc comments form <noreply@postgresql.org> wrote:
> 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)');
> ^ ^
> While not an Error, still...
See 8.17.3. Inclusive and Exclusive Bounds
This is an example with an inclusive lower bound "[" and an exclusive
upper bound ")".
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Start with [ , end with )
2018-04-23 13:00 Start with [ , end with ) PG Doc comments form <noreply@postgresql.org>
2018-04-24 03:37 ` Re: Start with [ , end with ) Mike Toews <mwtoews@gmail.com>
@ 2018-04-24 05:09 ` Jonathan S. Katz <jkatz@postgresql.org>
0 siblings, 0 replies; 3+ messages in thread
From: Jonathan S. Katz @ 2018-04-24 05:09 UTC (permalink / raw)
To: Mike Toews <mwtoews@gmail.com>; +Cc: yonatanhak@gmail.com; pgsql-docs@lists.postgresql.org
> On Apr 23, 2018, at 8:37 PM, Mike Toews <mwtoews@gmail.com> wrote:
>
> On 24 April 2018 at 01:00, PG Doc comments form <noreply@postgresql.org> wrote:
>> 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)');
>> ^ ^
>> While not an Error, still...
>
> See 8.17.3. Inclusive and Exclusive Bounds
>
> This is an example with an inclusive lower bound "[" and an exclusive
> upper bound ")”.
When dealing with date/time ranges, it’s a very common use case to have
an inclusive lower-bound and exclusive upper-bound, especially when
dealing with scheduling.
Jonathan
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2018-04-24 05:09 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-04-23 13:00 Start with [ , end with ) PG Doc comments form <noreply@postgresql.org>
2018-04-24 03:37 ` Re: Start with [ , end with ) Mike Toews <mwtoews@gmail.com>
2018-04-24 05:09 ` Re: Start with [ , end with ) Jonathan S. Katz <jkatz@postgresql.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox