Re: [SQL] BETWEEN

[Tom Lane]

Joseph Shraibman <[EMAIL PROTECTED]> 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