Re: Didn't correct output for LTRIM function
| От | Guillaume Lelarge |
|---|---|
| Тема | Re: Didn't correct output for LTRIM function |
| Дата | |
| Msg-id | CAECtzeXyGMHamdC41ZrZ1oMfgyNpRKABpvWJupr7eGJ=CT2ekA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Didn't correct output for LTRIM function (PG Doc comments form <noreply@postgresql.org>) |
| Ответы |
Re: Didn't correct output for LTRIM function
|
| Список | pgsql-docs |
Le lun. 13 juin 2022 à 10:06, PG Doc comments form <noreply@postgresql.org> a écrit :
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/14/bug-reporting.html
Description:
First check the output of "select LTRIM(' startech academy ', ' sta');"
output is "rtech academy "
now the thing is output of "select LTRIM(' startech academy ', ' star');"
output is "ech academy "
the question is where is 't'?
It's trimmed, because you asked t to be removed. It trims every single character at the beginning of the string till it encounters another character. The doc example makes it more clear:
ltrim('zzzytest', 'xyz') → test
The problem is when we do LTRIM for trimming the first four characters, it
trims the first five characters. but in the case of doing three characters,
it gives the correct output.
Both outputs are correct actually.
--
Guillaume.
В списке pgsql-docs по дате отправления: