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: | Raw Message | Whole Thread | 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 |