Re: Comparison Operator problem

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/ ------------