Thread: cast question

Running PostgreSQL 7.2.1 on RedHat Linux 7.2  ver. 2.4.7-10

How can I cast character to numeric?  I looked at 'to_number' and
I don't believe I'm doing it correctly.

Any examples would be helpful.

Thanks!

-X

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@laokoon.IN-Berlin.DE
Beam me up, Scotty. There is no intelligent live down in Redmond.