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@comptechnews.com ---------
-- CompTechNews Message Board http://www.comptechnews.com/ --
-- CompTechServ Tech Services http://www.comptechserv.com/ --
---------- http://www.comptechnews.com/~reaster/ ------------