pg.ddx.io pgsql-docs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Example for intersection operator is wrong 2+ messages / 2 participants [nested] [flat]
* Example for intersection operator is wrong @ 2016-07-14 16:28 etulsky@gmail.com 0 siblings, 1 reply; 2+ messages in thread From: etulsky@gmail.com @ 2016-07-14 16:28 UTC (permalink / raw) To: pgsql-docs 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). -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Example for intersection operator is wrong @ 2016-07-14 17:36 Tom Lane <tgl@sss.pgh.pa.us> parent: etulsky@gmail.com 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2016-07-14 17:36 UTC (permalink / raw) To: etulsky@gmail.com; +Cc: pgsql-docs 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 -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2016-07-14 17:36 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2016-07-14 16:28 Example for intersection operator is wrong etulsky@gmail.com 2016-07-14 17:36 ` Tom Lane <tgl@sss.pgh.pa.us>
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