Markus Bertheau writes:
> shouldn't
>
> 'between 1 and 7'
>
> return the same results as
>
> 'between 7 and 1'
This question might have been interesting 10 or 15 years ago when the SQL
standard was written, but today the answer is no.
What you're looking for is the syntax BETWEEN SYMMETRIC 1 AND 7, which is
new in SQL99 and not yet implemented in PostgreSQL.
--
Peter Eisentraut peter_e@gmx.net