| From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Cc: | kes-kes(at)yandex(dot)ru |
| Subject: | Improve examples for range operators |
| Date: | 2019-02-20 12:27:26 |
| Message-ID: | 155066564653.1372.8375190273475381681@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/functions-range.html
Description:
Hi.
It would be nice if next examples:
<< strictly left of int8range(1,10) << int8range(100,110) t
>> strictly right of int8range(50,60) >> int8range(20,30) t
&< does not extend to the right of int8range(1,20) &< int8range(18,20)
t
&> does not extend to the left of int8range(7,20) &> int8range(5,10) t
are extended by:
**not** strictly left of, **not** strictly right of, **extends** to the
right of, **extends** to the left of
Because without manual experiments I can not imagine the ranges that cause
'false' result for the examples above.
Thank you.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Doc comments form | 2019-02-20 12:47:04 | Update to equivalent SQL in 8.1.4. Serial Types |
| Previous Message | PG Doc comments form | 2019-02-19 10:48:05 | pg_upgrade |