Re: ERROR: operator does not exist: integer !=- integer - Mailing list pgsql-hackers

From William ZHANG
Subject Re: ERROR: operator does not exist: integer !=- integer
Date
Msg-id esga5o$1nde$1@news.hub.org
Whole thread Raw
In response to Re: ERROR: operator does not exist: integer !=- integer  (Andrew - Supernews <andrew+nonews@supernews.com>)
List pgsql-hackers
I get it. scan.l converts '!=' to '<>':
   644                     /* Convert "!=" operator to "<>" for 
compatibility */   645                     if (strcmp(yytext, "!=") == 0)   646                         yylval.str =
pstrdup("<>");  647                     else   648                         yylval.str = pstrdup(yytext);
 


""Joshua D. Drake"" <jd@commandprompt.com>
>
> Well yes it will work if you add a space, but technically the problem is 
> the query should be written like this:
>
> 1 <>-1 or 1 <> -1
>
> Joshua D. Drake 




pgsql-hackers by date:

Previous
From: Sherry Moore
Date:
Subject: Re: Bug: Buffer cache is not scan resistant
Next
From: Sherry Moore
Date:
Subject: Re: NTA access on Solaris