Re: cast varchar to numeric/money

From: Bruno Wolff III <bruno(at)wolff(dot)to>
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 17:55:23
Message-ID: 20031121175523.GA4065@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, Nov 21, 2003 at 11:47:42 -0600,
Yudie <yudie(at)axiontech(dot)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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Gaetano Mendola 2003-11-21 18:01:32 Re: How to quote date value?
Previous Message Yudie 2003-11-21 17:47:42 cast varchar to numeric/money