Re: between syntax

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