| From: | Christoph Dalitz <christoph(dot)dalitz(at)hs-niederrhein(dot)de> |
|---|---|
| To: | chris(at)wild(dot)net |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Typcasting |
| Date: | 2003-01-06 19:01:49 |
| Message-ID: | 20030106200149.62da4787.christoph.dalitz@hs-niederrhein.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Date: Mon, 6 Jan 2003 10:40:09 -0600
From: "Chris Boget" <chris(at)wild(dot)net>
Subject: Typcasting
>
> I'm told that I need to cast the value manually.
> I've looked up the CAST function and tried everything that I
> could think of but nothing seems to work. I can't, for the life
> of me, move the data over.
> I can I cast a field value? Is there any other way to do what
> I'm trying to do?
>
Cast only works between compatible data types (int to float etc.)
In your case, to_number() should do what you need.
Christoph Dalitz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2003-01-06 19:05:57 | Re: [GENERAL] www.postgresql.org |
| Previous Message | Ren Salomo | 2003-01-06 19:00:18 | Re: refcursor |