Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bNkZN-0005PO-Nt for pgsql-docs@arkaria.postgresql.org; Thu, 14 Jul 2016 17:37:05 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bNkZN-0007wk-7L for pgsql-docs@arkaria.postgresql.org; Thu, 14 Jul 2016 17:37:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bNkZM-0007wU-N1 for pgsql-docs@postgresql.org; Thu, 14 Jul 2016 17:37:04 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bNkZF-00022Q-2s for pgsql-docs@postgresql.org; Thu, 14 Jul 2016 17:37:04 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id u6EHasah008267; Thu, 14 Jul 2016 13:36:54 -0400 From: Tom Lane To: etulsky@gmail.com cc: pgsql-docs@postgresql.org Subject: Re: Example for intersection operator is wrong In-reply-to: <20160714162812.1425.65054@wrigleys.postgresql.org> References: <20160714162812.1425.65054@wrigleys.postgresql.org> Comments: In-reply-to etulsky@gmail.com message dated "Thu, 14 Jul 2016 16:28:12 -0000" Date: Thu, 14 Jul 2016 13:36:54 -0400 Message-ID: <8266.1468517814@sss.pgh.pa.us> X-Pg-Spam-Score: -3.2 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org 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