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? +
++++++++++++++++++++++++++++++++++
