Re: Casting Varchar to Numeric - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Casting Varchar to Numeric
Date
Msg-id 20011127081235.A20315-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Casting Varchar to Numeric  ("Andy Marden" <amarden@usa.net>)
List pgsql-general
On Tue, 27 Nov 2001, Andy Marden wrote:

> In PostgreSQL, it seems that an error is thrown up if an implicit conversion
> is attempted, and the only explicit conversion seems to be to_number(value,
> format) which doesn't do what's needed generically enough.
>
> I can't believe that this isn't possible - can anyone point me in the right
> direction?

I don't think anyone's written numeric(text) yet, so there is currently
no conversion function for the two types. If you write one and name it
as above, you should be able to get conversions between the two types.


pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: Timing a query
Next
From: David Wheeler
Date:
Subject: Re: DBD::Pg BYTEA Character Escaping