Re: trim(both) problem?

by sszabo@[EMAIL PROTECTED] (Stephan Szabo) Apr 25, 2008 at 01:45 PM

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.

-- 
Sent via pgsql-sql mailing list (pgsql-sql@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql