[Monetdb-developers] BETWEEN; SQL92 etc.
Fabian.Groffen at cwi.nl
Thu Aug 21 14:21:16 CEST 2008
On 21-08-2008 14:16:24 +0200, Stefan de Konink wrote:
> 6) "X BETWEEN Y AND Z" is equivalent to "X>=Y AND X<=Z".
> If between is equivalent to the above, why would call it between? I
> wonder why the order should be Y < Z for it to work. Wouldn't it be much
> more functional if it took two arbitrary numbers where order doesn't count?
Noone here says SQL is a good standard, but alas, it's the standard.
More information about the developers-list