Re: BUG #14441: trim function bug (hit a keyword somewhere internally) - Mailing list pgsql-bugs

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.