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
