Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] BUG #14478: Right Trim trims too much? - Mailing list pgsql-bugs

From Nathanael Terrien
Subject Re: [BUGS] BUG #14478: Right Trim trims too much?
Date
Msg-id af4cb1f0b64d4634b3b5466762fdabdd@EXCH2013.mustinformatique.fr
Whole thread Raw
In response to Re: [BUGS] BUG #14478: Right Trim trims too much?  (Terje Elde <terje@elde.net>)
Responses Re: [BUGS] BUG #14478: Right Trim trims too much?
List pgsql-bugs
Tree view

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?

 

 


On 26 Dec 2016, at 10:36, nte@mustinformatique.fr wrote:

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.

 

IOW, works as intended and advertised.

 

Doc here:

 

Terje

pgsql-bugs by date:

Previous
From: Terje Elde
Date:
Subject: Re: [BUGS] BUG #14478: Right Trim trims too much?
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14478: Right Trim trims too much?