Postgres Pro
Downloads
Home   >   mailing lists

Re: between syntax - Mailing list pgsql-sql

From Tom Lane
Subject Re: between syntax
Date
Msg-id 26131.1005925405@sss.pgh.pa.us
Whole thread Raw
In response to between syntax  (Markus Bertheau <twanger@bluetwanger.de>)
List pgsql-sql
Tree view 
Markus Bertheau <twanger@bluetwanger.de> 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

pgsql-sql by date:

Previous
From: Andriy Pyrozhenko
Date:
Subject: SQL
Next
From: Jeff Eckermann
Date:
Subject: Re: Insert values from one existing table into a new table.