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'.
select TRIM(LEADING 'exclude' FROM 'C001');
Will not strip trim anything as expected.
Cheers