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.