I believe the standard way is CAST(1.1 as numeric) But the following should also work: 1.1::numeric Stephan Szabo [EMAIL PROTECTED] On Tue, 15 Aug 2000, g wrote: > I need to know how to cast types. Here's my basic problem: > I'm trying to: > > update products set list_price = gsa_price * 1.1 where list_price = > gsa_price; > > The error I get back is: > > ERROR: Unable to identify an operator '*' for types 'numeric' and > 'float8' You will have to retype this query using an explicit cast > > So, I'm assuming that I need to cast the value 1.1 as a numeric so that I > will be multiplying a numeric times a numeric. > > Then I realized I had no idea what the syntax to do the cast was.
