Thread: Comparison Operator problem
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? +
++++++++++++++++++++++++++++++++++
On Tuesday 09 January 2001 16:15, John Burski wrote: > 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> Maybe a cast: cost > .99::numeric(6,2); -- -------- Robert B. Easter reaster@comptechnews.com --------- -- CompTechNews Message Board http://www.comptechnews.com/ -- -- CompTechServ Tech Services http://www.comptechserv.com/ -- ---------- http://www.comptechnews.com/~reaster/ ------------
Just the ticket! Thanks! "Robert B. Easter" wrote: > On Tuesday 09 January 2001 16:15, John Burski wrote: > > 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> > > Maybe a cast: > > cost > .99::numeric(6,2); > > -- > -------- Robert B. Easter reaster@comptechnews.com --------- > -- CompTechNews Message Board http://www.comptechnews.com/ -- > -- CompTechServ Tech Services http://www.comptechserv.com/ -- > ---------- http://www.comptechnews.com/~reaster/ ------------ -- 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? + ++++++++++++++++++++++++++++++++++