Skip site navigation (1) Skip section navigation (2)

Re: trim(both) problem?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: emilu(at)encs(dot)concordia(dot)ca
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: trim(both) problem?
Date: 2008-04-25 20:44:30
Message-ID: 28797.1209156270@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-sql
Emi Lu <emilu(at)encs(dot)concordia(dot)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

In response to

pgsql-sql by date

Next:From: Stephan SzaboDate: 2008-04-25 20:45:59
Subject: Re: trim(both) problem?
Previous:From: Emi LuDate: 2008-04-25 20:33:49
Subject: trim(both) problem?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group