Re: starne error from select 1!=-1 - Mailing list pgsql-general

"Andrus" <eetasoft@online.ee> writes:
> select 1!=-1
> ERROR:  operator does not exist: integer !=- integer

> Isn't this a bit stange ?

No.  We couldn't really parse this any other way without disallowing -
(and +) altogether in multi-character operator names.  There's a special
hack for SQL-spec compatibility, but it doesn't trigger in this case;
see

http://www.postgresql.org/docs/8.1/static/sql-syntax.html#SQL-SYNTAX-OPERATORS

            regards, tom lane