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