Postgres Pro
Downloads
Home   >   mailing lists

Re: between syntax - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: between syntax
Date
Msg-id 20011116082156.H18816-100000@megazone23.bigpanda.com
Whole thread Raw
In response to between syntax  (Markus Bertheau <twanger@bluetwanger.de>)
List pgsql-sql
Tree view 
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".

pgsql-sql by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: Insert values from one existing table into a new table.
Next
From: "Josh Berkus"
Date:
Subject: Re: Help with INSERT into 2 tables