Re: trim(both) problem?

--- Emi Lu <emilu@encs.concordia.ca> wrote:
> 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?

you misread - '<BR/>' argument is a list of characters, _not_ a string.change 'ROI' to 'XOI' and you'll see.

     ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ