Re: between syntax

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Markus Bertheau <twanger(at)bluetwanger(dot)de>
Cc: postgres sql list <pgsql-sql(at)postgresql(dot)org>
Subject: Re: between syntax
Date: 2001-11-16 16:38:03
Message-ID: Pine.LNX.4.30.0111161719480.644-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)gmx(dot)net

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-11-16 16:39:36 Re: Question
Previous Message Stephan Szabo 2001-11-16 16:23:29 Re: between syntax