On Fri, 25 Apr 2008, Emi Lu wrote:
> Isn't this a bug about trim both.
> select trim(both '<BR/>' from '<BR/>ROI Engineering Inc.');
> 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.
In response to
pgsql-sql by date
|Next:||From: Fernando Hevia||Date: 2008-04-25 21:03:14|
|Subject: Re: trim(both) problem?|
|Previous:||From: Tom Lane||Date: 2008-04-25 20:44:30|
|Subject: Re: trim(both) problem? |