Joseph Shraibman <jks(at)selectacast(dot)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.
regards, tom lane