On Fri, 25 Apr 2008, Emi Lu wrote:
> Hi,
>
> Isn't this a bug about trim both.
>
> select trim(both '<BR/>' from '<BR/>ROI Engineering Inc.');
> btrim
> ---------------------
> OI Engineering Inc.
> (1 row)
>
>
> "R" is missing? How?
Trim doesn't do what you think it does. The '<BR/>' in the above is not a
string to remove it is a list of characters to remove. Thus, the R is
removed as it matches a character given.