Comparison Operator problem

Поиск
Список
Период
Сортировка
От John Burski
Тема Comparison Operator problem
Дата
Msg-id 3A5B7F86.E83F4BFE@911ep.com
обсуждение исходный текст
Ответы Re: Comparison Operator problem  ("Robert B. Easter" <reaster@comptechnews.com>)
Список pgsql-novice
I was working on a small "lesson" at home last night when I encountered
a strange problem with both the greater-than and
greater-than-or-equal-to comparison operators.  Below are both the
description of the table I was running the query against, the one of the
queries that caused the problem, and the error message it produced.

<snip>
      Table "products_tbl"
 Attribute |     Type     | Modifier
-----------+--------------+----------
 prod_id   | varchar(10)  | not null
 prod_desc | varchar(40)  | not null
 cost      | numeric(6,2) | not null
Index: products_tbl_pkey

john=# select * from products_tbl
john-# where cost > .99;
ERROR:  Unable to identify an operator '>' for types 'numeric' and
'float8'
        You will have to retype this query using an explicit cast
</snip>

I did a "\do" to take a look at the available operators.  Both of them
were there for both "numeric" and "float8".

I should mention that I'm running 7.0.3 on Red Hat 6.1.  It was
installed via RPMs.

Thanks.

--
John Burski
Chief IT Cook and Bottlewasher
911 Emergency Products, St. Cloud, MN
(320) 656 0076       www.911ep.com

++++++++++++++++++++++++++++++++++
+ How's your cheese holding out? +
++++++++++++++++++++++++++++++++++

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: Advice on stored proc error handling versus Sybase?
Следующее
От: "Robert B. Easter"
Дата:
Сообщение: Re: Comparison Operator problem