Date: Tue, 29 Nov 2016 22:09:32 -0800
From: David Gould <daveg@sonic.net>
To: mark.pether@gmail.com
Cc: pgsql-bugs@postgresql.org
Subject: Re: BUG #14441: trim function bug (hit a keyword somewhere
 internally)
Message-ID: <20161129220932.123e13a1@engels>
In-Reply-To: <20161130011710.6539.53657@wrigleys.postgresql.org>
References: <20161130011710.6539.53657@wrigleys.postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-bugs-owner@postgresql.org

On Wed, 30 Nov 2016 01:17:10 +0000
mark.pether@gmail.com wrote:

> The following bug has been logged on the website:
> 
> Bug reference:      14441
> Logged by:          mark pether
> Email address:      mark.pether@gmail.com
> PostgreSQL version: 9.5.4
> Operating system:   macos
> Description:        
> 
> select TRIM(LEADING 'EXCLUDE' FROM 'C001');
> 
> Will incorrectly strip off the 'C' leaving '001'.


Perhaps I'm misreading the doc, but that looks like the correct result.
That is, any character in 'EXCLUDE' will be stripped from the leading part of
'C001', ie, the 'C'. Why do you think this is a bug?

-dg


-- 
David Gould                                   daveg@sonic.net
If simplicity worked, the world would be overrun with insects.


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs