Обсуждение: pg_dumpall problems
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. Thanks for info ----------------------------------------- Water overcomes the stone; Without substance it requires no opening; This is the benefit of taking no action. Lao-Tse Brian Knox Senior Systems Engineer brian@govshops.com
I believe the standard way is CAST(1.1 as numeric) But the following should also work: 1.1::numeric Stephan Szabo sszabo@bigpanda.com 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.
Thanks. I figured out the CAST later but didn't know the 1.1::numeric syntax. ----------------------------------------- Water overcomes the stone; Without substance it requires no opening; This is the benefit of taking no action. Lao-Tse Brian Knox Senior Systems Engineer brian@govshops.com On Tue, 15 Aug 2000, Stephan Szabo wrote: > I believe the standard way is > CAST(1.1 as numeric) > > But the following should also work: > 1.1::numeric > > Stephan Szabo > sszabo@bigpanda.com > > 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. >