Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 9B66C2E003A
	for <pgsql-sql-postgresql.org@developer.postgresql.org>;
	Fri, 25 Apr 2008 18:48:32 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 16641-04
	for <pgsql-sql-postgresql.org@developer.postgresql.org>;
	Fri, 25 Apr 2008 18:48:29 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from web54307.mail.re2.yahoo.com (web54307.mail.re2.yahoo.com
	[206.190.49.117])
	by developer.postgresql.org (Postfix) with SMTP id 680F22E0032
	for <pgsql-sql@postgresql.org>; Fri, 25 Apr 2008 18:48:29 -0300 (ADT)
Received: (qmail 31028 invoked by uid 60001); 25 Apr 2008 21:48:26 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
	b=P5vWWue82lKAFLYuGrNwcUaZplnn8n7VTncF8XPPX8cFOwWELkQi2ldHPX/FdVPw1pWOYtqTKdS7tAC180QOT6pWEXX1isKGHYUbB8Nsv6BrFaRCXWV1LdVEn4F04Jjww1Y1FyyoRT9eiEDRXWepNi3XtQJjM4L6LPtlEkh13Ug=;
X-YMail-OSG: 
 kzgbgFEVM1mhwlgEWsOsUxPbJZ12pW.UZHFYMLml46IyVq00v3loA4pXc3w_ClS5UDuoXTlE4.7BqiZGAUiJWiPCSC3bc0Z5UdmVr0UzjCJdAapn2jWVxtuRGQ--
Received: from [69.227.19.53] by web54307.mail.re2.yahoo.com via HTTP;
	Fri, 25 Apr 2008 14:48:26 PDT
Date: Fri, 25 Apr 2008 14:48:26 -0700 (PDT)
From: chester c young <chestercyoung@yahoo.com>
Subject: Re: trim(both) problem?
To: emilu@encs.concordia.ca
Cc: sql pgsql <pgsql-sql@postgresql.org>
In-Reply-To: <4812402D.7080404@encs.concordia.ca>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <930443.30930.qm@web54307.mail.re2.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200804/179
X-Sequence-Number: 30718

--- Emi Lu <emilu@encs.concordia.ca> wrote:
 
> Isn't this a bug about trim both.
> 
>   select trim(both '<BR/>' from '<BR/>ROI Engineering Inc.');
>          btrim
> ---------------------
>   OI Engineering Inc.
> (1 row)
> 
> 
> "R" is missing? How?

you misread - '<BR/>' argument is a list of characters, _not_ a string.
 change 'ROI' to 'XOI' and you'll see.


      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ