Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
> jeewan wrote:
>> ERROR: function pg_catalog.rtrim(numeric, integer) does not exist
>> LINE t: ...ct col2_date,col4_int,colt_timestamp,col5_numeric,trim(trail...
> this is not a bug - there is no version of of trim() that works on
> numeric(and I'm not sure why one would want this).
Perhaps he's looking for round()?
regards, tom lane