Tino Wildenhain <[EMAIL PROTECTED]> writes:
>> to_char() and back to numeric shouldn't be a problem within the database
>> and we have regex too if anything fails. I don't think you need to
>> dump and edit the dump to achive that.
> Ah sorry forget that... neither to_char nor cast to text works. Really a
> horrible datatype :(
If you do it within plpgsql it should work. Just assign the money value
to a text variable (or vice versa).
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
