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

Sorry, I misread the document it's not a bug, doco was unclear.

It replaces the largest match which may be all characters or simply
individual characters. I realised this after I created the bug.

I have switched to REGEXP_REPLACE to do the correct operation.

Regards

On Wed, Nov 30, 2016 at 5:09 PM, David Gould <daveg@sonic.net> wrote:

> 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.
>