Ok, I misunderstood the documentation. The way it works is logical.
Thank you.
De : Terje Elde [mailto:terje@elde.net] Envoyé : lundi 26 décembre 2016 15:52 À : Nathanael Terrien <nte@mustinformatique.fr> Cc : pgsql-bugs@postgresql.org Objet : Re: [BUGS] BUG #14478: Right Trim trims too much?
Not sure if a bug or if I'm missing something but this query produces weird results with TRIM and TRIM: SELECT DISTINCT TRIM(TRAILING FROM 'cnam_lpp_histo_io','_io')
The devil is in the details. Trim won't remove the string "_io", it'll trim off the characters "_", "i" and "o". And with that logic, the "o" at the end of "histo" is correctly removed as well.