Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e5KIH9M27950 for ; Tue, 20 Jun 2000 14:17:11 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id OAA01153; Tue, 20 Jun 2000 14:16:53 -0400 (EDT) To: Joseph Shraibman cc: "pgsql-sql@postgresql.org" Subject: Re: BETWEEN In-reply-to: <394A7B4F.6E46321B@selectacast.net> References: <394A7B4F.6E46321B@selectacast.net> Comments: In-reply-to Joseph Shraibman message dated "Fri, 16 Jun 2000 15:09:03 -0400" Date: Tue, 20 Jun 2000 14:16:53 -0400 Message-ID: <1150.961525013@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200006/183 Joseph Shraibman writes: > Why is BETWEEN inclusive? Because the SQL92 spec says so: 6) "X BETWEEN Y AND Z" is equivalent to "X>=Y AND X<=Z". > I had assumed that it was like the english > between, which is exclusive. That's debatable... regards, tom lane