On Sep 11, 2007, at 13:42 , David Fetter wrote:
I believe that foo!=bar without white space should simply error out
because there is no reasonable, unambiguous way to parse it. Here's
what we get right now:
What's ambigious about it? An operator cannot include a space, so !=
(no space) is *always* interpreted as one operator: not equals (<>).
space (! and = are separate operators), so ! is factorial.
test=# SELECT (2! =0);
?column?
----------
f
(1 row)
test=# SELECT (2 ! =0);
?column?
----------
f
(1 row)
test=# SELECT (2 ! = 0);
?column?
----------
f
(1 row)
no space, so != is one operator,
test=# SELECT (2!=0);
?column?
----------
t
(1 row)
test=# SELECT (2 != 0);
?column?
----------
t
(1 row)
test=# SELECT (2 !=0);
?column?
----------
t
(1 row)
Michael Glaesemann
grzm seespotcode net
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
