Re: Missing closing ]

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mishchenkoa(at)google(dot)com
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Missing closing ]
Date: 2023-10-04 16:26:46
Message-ID: 2599189.1696436806@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

PG Doc comments form <noreply(at)postgresql(dot)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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Daniel Fredouille 2023-10-05 00:04:41 Re: unnest multirange, returned order
Previous Message PG Doc comments form 2023-10-04 14:45:32 Missing closing ]