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? +
++++++++++++++++++++++++++++++++++