Le lun. 13 juin 2022 à 10:06, PG Doc comments form <nore...@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 https://www.postgresql.org/docs/14/functions-string.html 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.
