[Monetdb-developers] BETWEEN; SQL92 etc.
21 Aug
2008
21 Aug
'08
12:16 p.m.
Hi, 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? Stefan
21 Aug
21 Aug
12:21 p.m.
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.
5972
Age (days ago)
5972
Last active (days ago)
1 comments
2 participants
participants (2)
-
Fabian Groffen -
Stefan de Konink