Emi Lu <emilu(at)encs(dot)concordia(dot)ca> writes:
> select trim(both '<BR/>' from '<BR/>ROI Engineering Inc.');
> 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.
regards, tom lane
In response to
pgsql-sql by date
|Next:||From: Stephan Szabo||Date: 2008-04-25 20:45:59|
|Subject: Re: trim(both) problem?|
|Previous:||From: Emi Lu||Date: 2008-04-25 20:33:49|
|Subject: trim(both) problem?|