Re: Inconsistent or incomplete behavior obverse in where clause

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Inconsistent or incomplete behavior obverse in where clause
Дата
Msg-id 10295.1037126087@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Inconsistent or incomplete behavior obverse in where clause  (Paul Ogden <pogden@claresco.com>)
Список pgsql-sql
Paul Ogden <pogden@claresco.com> writes:
>   select count(wuid) from WU where wuActive = 0.0 --throws the 
> following exception:

> "Unable to identify an operator '=' for types 'numeric' and 'double
> precision' You will have to retype this query using an explicit cast"

This is fixed as of 7.3.  (We still have related issues for smallint
and bigint columns, unfortunately.)
        regards, tom lane


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Josh Berkus"
Дата:
Сообщение: Re: Inconsistent or incomplete behavior obverse in where
Следующее
От: "Rajesh Kumar Mallah."
Дата:
Сообщение: Re: Output of function into a file