Received: from megazone.bigpanda.com ([63.150.15.178]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAGGNPm33937 for ; Fri, 16 Nov 2001 11:23:28 -0500 (EST) (envelope-from sszabo@megazone23.bigpanda.com) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id CC2FCD5E5; Fri, 16 Nov 2001 08:23:29 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id C1E145BE4; Fri, 16 Nov 2001 08:23:29 -0800 (PST) Date: Fri, 16 Nov 2001 08:23:29 -0800 (PST) From: Stephan Szabo To: Markus Bertheau Cc: postgres sql list Subject: Re: between syntax In-Reply-To: <1005910892.1215.2.camel@entwicklung01.cenes.de> Message-ID: <20011116082156.H18816-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200111/242 X-Sequence-Number: 5624 On 16 Nov 2001, Markus Bertheau wrote: > Good day, > > shouldn't > > 'between 1 and 7' > > return the same results as > > 'between 7 and 1' Don't think so, if I'm reading the spec correct, the conversion is: 6) "X BETWEEN Y AND Z" is equivalent to "X>=Y AND X<=Z".