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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
