String trim function - possible bug? - Mailing list pgsql-general

I am seeing weirdness using the trim function on a string:

This works as expected:

SELECT 'dhct:bn', trim(leading 'dhct:' from 'dhct:bn');
 ?column? | ltrim
----------+-------
 dhct:bn  | bn
(1 row)

However it fails for these cases:

SELECT 'dhct:dn', trim(leading 'dhct:' from 'dhct:dn');
 ?column? | ltrim
----------+-------
 dhct:dn  | n
(1 row)

SELECT 'dhct:cn', trim(leading 'dhct:' from 'dhct:cn');
 ?column? | ltrim
----------+-------
 dhct:cn  | n
(1 row)

The second case truncates an extra character (which is unwanted or
unexpected).

It fails for both 8.1.4 and 8.2.3.  It seems if the first character after
the 'dhct:' is a 'd' or a 'c' it truncates it as well.  I have not tested
every letter of the alphabet yet.

Any suggestions?

Thanks,
Woody

----------------------------------------
iGLASS Networks
211-A S. Salem St
Apex NC 27502
(919) 387-3550 x813
www.iglass.net