Postgres Pro
Downloads
Home   >   mailing lists

Re: trim(both) problem? - Mailing list pgsql-sql

From Tom Lane
Subject Re: trim(both) problem?
Date
Msg-id 28797.1209156270@sss.pgh.pa.us
Whole thread Raw
In response to trim(both) problem?  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Emi Lu
Date:
Subject: trim(both) problem?
Next
From: Stephan Szabo
Date:
Subject: Re: trim(both) problem?