Roland Bouman wrote:
Hi Jim,
It's non-standard, but I've always been partial to the syntactic sugar:
<expression> [ not ] between <expression> and <expression>
In other words, "a not between 1 and 3" is nicer than "not a between 1 and
3".
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>
I sit corrected. Anyone else want to correct me? Anyone? Anyone?
--
Jim Starkey
President, NimbusDB, Inc.
978 526-1376
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
