Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAGFhQm32607 for ; Fri, 16 Nov 2001 10:43:26 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id fAGFhPc26134; Fri, 16 Nov 2001 10:43:25 -0500 (EST) To: Markus Bertheau cc: postgres sql list Subject: Re: between syntax In-reply-to: <1005910892.1215.2.camel@entwicklung01.cenes.de> References: <1005910892.1215.2.camel@entwicklung01.cenes.de> Comments: In-reply-to Markus Bertheau message dated "16 Nov 2001 12:41:31 +0100" Date: Fri, 16 Nov 2001 10:43:25 -0500 Message-ID: <26131.1005925405@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200111/240 X-Sequence-Number: 5622 Markus Bertheau writes: > shouldn't > 'between 1 and 7' > return the same results as > 'between 7 and 1' > ? Nope. SQL92 section 8.3 defines BETWEEN thusly: 6) "X BETWEEN Y AND Z" is equivalent to "X>=Y AND X<=Z". regards, tom lane