Example for intersection operator is wrong
Example for intersection operator is wrong
От:
etulsky@gmail.com
Дата:
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.2/static/functions-range.html Description: On the page https://www.postgresql.org/docs/9.2/static/functions-range.html it gives an example for the intersection of range (5,15) and range (10,20) as [10,15). But 10 isn't included in the second range; the actual output of this operator is [11,15).
Re: Example for intersection operator is wrong
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
etulsky@gmail.com writes: > The following documentation comment has been logged on the website: > Page: https://www.postgresql.org/docs/9.2/static/functions-range.html > Description: > On the page https://www.postgresql.org/docs/9.2/static/functions-range.html > it gives an example for the intersection of range (5,15) and range (10,20) > as [10,15). But 10 isn't included in the second range; the actual output of > this operator is [11,15). Uh, no, it isn't: regression=# select int8range(5,15) * int8range(10,20); ?column? ---------- [10,15) (1 row) You'd be correct if int8range(10,20) produced '(10,20)', but it produces '[10,20)'. regards, tom lane