hi!only for ask, there is a way to deactivate type validation, so i can do
select rtrim(number_field) from table ; with no error and the message: "You might need to explicit type casts"
this is postgres 8.3.1.