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
I missed the first post and can't seem to search for it - so correct
me if I am missing something.
Isn't the problem here a missing space? != is a valid operator and -1
is the value you are comparing to. !=-1 is not valid but != -1 is
correct and what I assume you are looking to achieve.
"William ZHANG" <[EMAIL PROTECTED]> writes:
> backend> select -1 !=-1;
> ERROR: operator does not exist: integer !=- integer at character 11
This is not a bug.
regards, tom lane
---(end of broadcast)---
TIP 6: explain analy
Here is the steps to reproduce it in CVS HEAD:
$ uname -a
Linux os-server 2.6.9-11.19AX #1 Fri Aug 5 05:12:07 EDT 2005 i686 i686 i386
GNU/Linux
$ ./postgres --single -D $HOME/pgsql/data postgres
PostgreSQL stand-alone backend 8.3devel
backend> show server_version;
1: server_version
Andrew - Supernews wrote:
On 2007-03-04, William ZHANG <[EMAIL PROTECTED]> wrote:
Here is the steps to reproduce it in CVS HEAD:
backend> select -1 !=-1;
This arguably isn't a bug, because != is not a standard SQL operator, and
therefore !=- can legitimately be defined as a single operator by
On 2007-03-04, William ZHANG <[EMAIL PROTECTED]> wrote:
> Here is the steps to reproduce it in CVS HEAD:
> backend> select -1 !=-1;
This arguably isn't a bug, because != is not a standard SQL operator, and
therefore !=- can legitimately be defined as a single operator by the user.
--
Andrew, Sup
