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