r a for the "both" one.
I don't know why, but could not use '*?'
Since in no instance my_triming_string was at the extremlity of the sting, I
did not need it, but I guess something like '(|.+)my_triming_string'could have
worked
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 r
