Re: cast varchar to numeric/money

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: Yudie <yudie(at)axiontech(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: cast varchar to numeric/money
Date: 2003-11-21 19:12:44
Message-ID: 3FBE63AC.70300@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message terry 2003-11-21 19:16:06 Re: How to quote date value?
Previous Message Stephan Szabo 2003-11-21 19:04:18 Re: How to quote date value?