| From: | g <brian(at)wuwei(dot)govshops(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pg_dumpall problems |
| Date: | 2000-08-15 21:38:04 |
| Message-ID: | Pine.LNX.4.21.0008151041440.1702-100000@wuwei.govshops.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)govshops(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2000-08-15 21:45:41 | Re: bytea question |
| Previous Message | Stephan Szabo | 2000-08-15 21:36:33 | Re: pg_dumpall problems |