--- Emi Lu <[EMAIL PROTECTED]> wrote:
> Isn't this a bug about trim both.
>
> select trim(both '' from 'ROI Engineering Inc.');
> btrim
> -
> OI Engineering Inc.
> (1 row)
>
>
> "R" is missing? How?
you misread - '' argument is a list of characters, _not_ a st
"Fernando Hevia" <[EMAIL PROTECTED]> writes:
>> Trim doesn't do what you think it does. The '' 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('ROI Engi
> -Mensaje original-
> De: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] En nombre de Stephan Szabo
> Enviado el: Viernes, 25 de Abril de 2008 17:46
> Para: Emi Lu
> CC: pgsql-sql@postgresql.org
> Asunto: Re: [SQL] trim(both) problem?
>
> On Fri, 25 Apr 2008, Emi Lu wrote:
>
> > Hi,
>
On Fri, 25 Apr 2008, Emi Lu wrote:
> Hi,
>
> Isn't this a bug about trim both.
>
> select trim(both '' from 'ROI Engineering Inc.');
> btrim
> -
> OI Engineering Inc.
> (1 row)
>
>
> "R" is missing? How?
Trim doesn't do what you think it does. The '' in the above
Emi Lu <[EMAIL PROTECTED]> writes:
> select trim(both '' from 'ROI Engineering Inc.');
> btrim
> -
> OI Engineering Inc.
> (1 row)
> "R" is missing? How?
The first argument of trim is a set, not a sequence --- it means trim
any characters belonging to this set.
Hi,
Isn't this a bug about trim both.
select trim(both '' from 'ROI Engineering Inc.');
btrim
-
OI Engineering Inc.
(1 row)
"R" is missing? How?
version
-
PostgreSQL 8.0.15 on i686-pc-linu
