Re: BETWEEN - Mailing list pgsql-sql

From Tom Lane
Subject Re: BETWEEN
Date
Msg-id 1150.961525013@sss.pgh.pa.us
Whole thread Raw
In response to BETWEEN  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-sql
Joseph Shraibman <jks@selectacast.net> writes:
> Why is BETWEEN inclusive?

Because the SQL92 spec says so:
        6) "X BETWEEN Y AND Z" is equivalent to "X>=Y AND X<=Z".

> I had assumed that it was like the english
> between, which is exclusive.

That's debatable...
        regards, tom lane


pgsql-sql by date:

Previous
From: Joseph Shraibman
Date:
Subject: BETWEEN
Next
From: Ice Planet
Date:
Subject: Type conversion