Re: Comparison Operator problem

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(at)comptechnews(dot)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? +
++++++++++++++++++++++++++++++++++