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

Поиск
Список
Период
Сортировка
От Paul Tilles
Тема doesn't recognize "!=-" (not equal to a negative value)
Дата
Msg-id 44B3DBB4.3080608@noaa.gov
обсуждение исходный текст
Ответы 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>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: pgsql vs mysql
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: SQL parsing suggestions?