Re: trim(both) problem? - Mailing list pgsql-sql

From chester c young
Subject Re: trim(both) problem?
Date
Msg-id 930443.30930.qm@web54307.mail.re2.yahoo.com
Whole thread Raw
In response to trim(both) problem?  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-sql
--- 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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: trim(both) problem?
Next
From: "Thomas Mueller"
Date:
Subject: Protection from SQL injection