Re: BUG #8335: trim() un-document behaviour

Running postgres 9.1.4 using pgAdmin3 on a macbook air intel OS 10.6

I just had this bug, using comma:

SELECT trim(trailing texte_natif , 'DATEDENAISSANCE' ) FROM CROP

returned the whole field, including the string 'DATEDENAISSANCE', but except
the very first character, the column being called rtrim.

Tryed to chang it to
SELECT trim(trailing texte_natif from 'DATEDENAISSANCE' ) FROM CROP

returned nothing ( as a dummy in postgres I can't say if it was null fields
or empty string...)


CROP.texte_natif is a quite long texte field,in which the STRING
'DATEDENAISSANCE can be present 0 to 3 times, and never before 20th
character

bests
Romain



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/BUG-8335-trim-un-document-behaviour-tp5765221p5766930.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.