Re: BUG #4841: like and trim queries - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4841: like and trim queries
Date
Msg-id 9467.1244300468@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #4841: like and trim queries  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: BUG #4841: like and trim queries
Next
From: Tiziano Valdemarin
Date:
Subject: installer typo bug