On Sep 12, 2008, at 4:20 PM, Roland Bouman wrote:
Hah! I thought that was non standard too...until Roy corrected me. I
looked it up:
ISO/IEC 9075-2:2003 (E)
8.3 <between predicate>
<between predicate> ::= <row value predicand> <between predicate
part 2>
<between predicate part 2> ::=
[ NOT ] BETWEEN [ ASYMMETRIC | SYMMETRIC ]
<row value predicand> AND <row value predicand>
So. Now what does MySQL say:
mysql> select 1 not between 2 and 3;
+-----------------------+
| 1 not between 2 and 3 |
+-----------------------+
| 1 |
+-----------------------+
all clear ;)
Or do we now have to discuss what this means:
select * from t1 where NOT c1 NOT BETWEEN 2 AND 3! :P
--
Paul McCullagh
PrimeBase Technologies
www.primebase.org
www.blobstreaming.org
pbxt.blogspot.com
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
