| From: | Terje Elde <terje(at)elde(dot)net> |
|---|---|
| To: | nte(at)mustinformatique(dot)fr |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #14478: Right Trim trims too much? |
| Date: | 2016-12-26 14:51:48 |
| Message-ID: | 8D6B90F8-6952-4342-93E5-66F7CDE42D66@elde.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
> On 26 Dec 2016, at 10:36, nte(at)mustinformatique(dot)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:
/docs/current/static/functions-string.html
Terje
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nathanael Terrien | 2016-12-26 14:56:32 | Re: BUG #14478: Right Trim trims too much? |
| Previous Message | nte | 2016-12-26 09:36:34 | BUG #14478: Right Trim trims too much? |