Re: Didn't correct output for LTRIM function

Thank you for the clarification.

On Mon, 13 Jun 2022, 4:27 am Guillaume Lelarge, <guillaume(at)lelarge(dot)info>
wrote:

> Le lun. 13 juin 2022 à 10:06, PG Doc comments form <noreply(at)postgresql(dot)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.
>