Re: trim(both) problem?

> -----Mensaje original-----
> De: pgsql-sql-owner(at)postgresql(dot)org
> [mailto:pgsql-sql-owner(at)postgresql(dot)org] En nombre de Stephan Szabo
> Enviado el: Viernes, 25 de Abril de 2008 17:46
> Para: Emi Lu
> CC: pgsql-sql(at)postgresql(dot)org
> Asunto: Re: [SQL] trim(both) problem?
>
> 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.
>

You could probably use instead:

select replace('<BR/>ROI Engineering Inc.', '<BR/>', '')