Re: pg_dumpall problems
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:
Show quoted text
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 castSo, 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.
Import Notes
Reply to msg id not found: Pine.LNX.4.21.0008151041440.1702-100000@wuwei.govshops.com
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:
Show quoted text
I believe the standard way is
CAST(1.1 as numeric)But the following should also work:
1.1::numericStephan Szabo
sszabo@bigpanda.comOn 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 castSo, 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.