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 [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to