From: | "Fernando Hevia" <fhevia(at)ip-tel(dot)com(dot)ar> |
---|---|
To: | "'Emi Lu'" <emilu(at)encs(dot)concordia(dot)ca> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: trim(both) problem? |
Date: | 2008-04-25 21:03:14 |
Message-ID: | 031701c8a717$c7458e90$8f01010a@iptel.com.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
> -----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/>', '')
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-04-25 21:26:27 | Re: trim(both) problem? |
Previous Message | Stephan Szabo | 2008-04-25 20:45:59 | Re: trim(both) problem? |