Re: BUG #14441: trim function bug (hit a keyword somewhere internally)

From: David Gould <daveg(at)sonic(dot)net>
To: mark(dot)pether(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14441: trim function bug (hit a keyword somewhere internally)
Date: 2016-11-30 06:09:32
Message-ID: 20161129220932.123e13a1@engels
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, 30 Nov 2016 01:17:10 +0000
mark(dot)pether(at)gmail(dot)com wrote:

> The following bug has been logged on the website:
>
> Bug reference: 14441
> Logged by: mark pether
> Email address: mark(dot)pether(at)gmail(dot)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(at)sonic(dot)net
If simplicity worked, the world would be overrun with insects.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message mark pether 2016-11-30 06:16:16 Re: BUG #14441: trim function bug (hit a keyword somewhere internally)
Previous Message mark.pether 2016-11-30 01:17:10 BUG #14441: trim function bug (hit a keyword somewhere internally)