Emi Lu <emilu@encs.concordia.ca> writes:
> select trim(both '<BR/>' from '<BR/>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.
regards, tom lane