Re: cast question

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.