Postgres Pro
Downloads
Home   >   mailing lists

Re: cast varchar to numeric/money - Mailing list pgsql-sql

From Tomasz Myrta
Subject Re: cast varchar to numeric/money
Date
Msg-id 3FBE63AC.70300@klaster.net
Whole thread Raw
In response to Re: cast varchar to numeric/money  ("Yudie" <yudie@axiontech.com>)
List pgsql-sql
Tree view 
Dnia 2003-11-21 19:26, Użytkownik Yudie napisał:
> I don't have to_numeric function in my 7.2.2 postgre.
> then it can resolve it with: 
> 
> cast(substr(varcharcolumn,0) as float4)

Read once again. The function is not "to_numeric", but "to_number".
You can read about this function in manual:
6.7. Data Type Formatting Functions

Regards,
Tomasz Myrta

pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: How to quote date value?
Next
From: Ian Barwick
Date:
Subject: Re: Compare strings which resembles each other