From: | Thomas Beutin <tyrone(at)laokoon(dot)IN-Berlin(dot)DE> |
---|---|
To: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: cast question |
Date: | 2002-12-10 21:00:58 |
Message-ID: | 20021210220058.B6015@laokoon.bug.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Dec 10, 2002 at 12:40:24PM -0500, Johnson, Shaunn wrote:
> Running PostgreSQL 7.2.1 on RedHat Linux 7.2 ver. 2.4.7-10
this is a little bit outdated, IMHO You should upgrade to at least
to 7.2.3. There were some bugs in earlier 7.2.x versions
> How can I cast character to numeric? I looked at 'to_number' and
> I don't believe I'm doing it correctly.
to_number('12,454.8-', '99G999D9S')
to_number('345', '9999')::smallint
>
> Any examples would be helpful.
for current release:
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/functions-formatting.html
There is just one example but a really good doc.
greetz,
-tb
--
Thomas Beutin tb(at)laokoon(dot)IN-Berlin(dot)DE
Beam me up, Scotty. There is no intelligent live down in Redmond.
From | Date | Subject | |
---|---|---|---|
Next Message | Lee Harr | 2002-12-10 21:37:19 | Re: PostgreSQL VS Mysql |
Previous Message | Greg Copeland | 2002-12-10 20:06:23 | Re: [mail] Re: 7.4 Wishlist |