Problem with numeric and operators

Поиск
Список
Период
Сортировка
Искать
От
DaVinci
Тема
Problem with numeric and operators
Дата
Msg-id
20010904140836.A15151@fangorn.net
Список
Дерево обсуждения
Problem with numeric and operators DaVinci <bombadil@wanadoo.es>
 Hi all.

 I have a problem with data type 'numeric'. If I have a field of type
 'numeric' (in this case 'foo') and execute next query:

 	select * from table_example where foo > 2.45

 I get error:

 	ERROR:  Unable to identify an operator '>' for types 'numeric' and 'float8'
	You will have to retype this query using an explicit cast

 What is the meaning of this? Is it a bug? What am I doing wrong?...

 Thanks.

 				David
В списке pgsql-general по дате отправления
От: Adam Manock
Дата:
Сообщение: Re: PL/java?
От: Oliver Elphick
Дата:
FAQ