[Monetdb-developers] BETWEEN; SQL92 etc.

Fabian Groffen 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:
> SQL92:
> 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 mailing list