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

From Bruno Wolff III
Subject Re: cast varchar to numeric/money
Date
Msg-id 20031121175523.GA4065@wolff.to
Whole thread Raw
In response to cast varchar to numeric/money  ("Yudie" <yudie@axiontech.com>)
List pgsql-sql
On Fri, Nov 21, 2003 at 11:47:42 -0600, Yudie <yudie@axiontech.com> wrote:
> Hi guys,
> 
> I know it's impossible to just cast varchar to any numeric datatype,
> but is there another function/ custom function or any way to force to do
> that convertion.

You can use to_number to go from text to numeric.


pgsql-sql by date:

Previous
From: "Yudie"
Date:
Subject: cast varchar to numeric/money
Next
From: Gaetano Mendola
Date:
Subject: Re: How to quote date value?