I am not sure if this will work, but you can try it

http://www.pgsql.cz/index.php/PostgreSQL_SQL_Tricks#Cast_to_varchar

Pavel

I appreciate your help, but UDTs don't have input/ouput functions unless you define them manually and I need this for all of my tables.

Thanks
Sim