Re: ERROR: operator does not exist: integer !=- integer

From: "William ZHANG" <uniware(at)zedware(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: ERROR: operator does not exist: integer !=- integer
Date: 2007-03-05 05:34:48
Message-ID: esga5o$1nde$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)commandprompt(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Luke Lonergan 2007-03-05 05:52:53 Re: Bug: Buffer cache is not scan resistant
Previous Message Gavin Sherry 2007-03-05 05:16:44 Re: Bug: Buffer cache is not scan resistant