Postgres Pro
Downloads
Home   >   mailing lists

doesn't recognize "!=-" (not equal to a negative value) - Mailing list pgsql-general

From Paul Tilles
Subject doesn't recognize "!=-" (not equal to a negative value)
Date
Msg-id 44B3DBB4.3080608@noaa.gov
Whole thread Raw
Responses Re: doesn't recognize "!=-" (not equal to a negative value)  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: doesn't recognize "!=-" (not equal to a negative  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: doesn't recognize "!=-" (not equal to a negative value)  ("Eric B. Ridge" <ebr@tcdi.com>)
Re: doesn't recognize "!=-" (not equal to a negative value)  ("Tim Hart" <tjhart@mac.com>)
Re: doesn't recognize "!=-" (not equal to a negative value)  (Oisin Glynn <me@oisinglynn.com>)
Re: doesn't recognize "!=-" (not equal to a negative  (Bruce Momjian <bruce@momjian.us>)
Re: doesn't recognize "!=-" (not equal to a negative value)  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
Tree view 
Version postgres 7.4.7:

Following sql

UPDATE tablename SET value = 0.0 where value!=-9.4;

results in the error message

ERROR:  operator does not exist: smallint !=- integer
HINT:  No operator matches the given name and argument type(s). You may
need to add explicit type casts.

Seems that postgres has a problem parsing a "not equal negative value".

Anybody know if this is fixed in later versions?

Paul Tilles

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: pgsql vs mysql
Next
From: "Merlin Moncure"
Date:
Subject: Re: SQL parsing suggestions?