why do i get 2 as answer for select length('aa '::char(6));

Поиск

Список

Период

Сортировка

От	john snow
Тема	why do i get 2 as answer for select length('aa '::char(6));
Дата	17 января 2018 г. 04:59:57
Msg-id	CAE67tvV20x9GtyPqfZdoK+WxxKYLC3SEjovw+xwGkVKcMqzsow@mail.gmail.com обсуждение исходный текст
Ответы	Re: why do i get 2 as answer for select length('aa '::char(6)); Re: why do i get 2 as answer for select length('aa '::char(6)); Re: why do i get 2 as answer for select length('aa '::char(6));
Список	pgsql-novice

as well as select length('aa'::char(6));

i thought if the string to be stored is shorter than specified length , it will be padded with spaces?

i'm using version 10.0 on windows 10

В списке pgsql-novice по дате отправления: