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

Поиск
Список
Период
Сортировка
От Andrej
Тема Re: why do i get 2 as answer for select length('aa '::char(6));
Дата
Msg-id CACMx3pP_6rX1YLJCDC4UR7d4JWtbuBZa=D47o16E9=aABpLLSQ@mail.gmail.com
обсуждение исходный текст
Ответ на why do i get 2 as answer for select length('aa '::char(6));  (john snow <ofbizfanster@gmail.com>)
Ответы Re: why do i get 2 as answer for select length('aa '::char(6));  (john snow <ofbizfanster@gmail.com>)
Список pgsql-novice
On 17 January 2018 at 14:59, john snow <ofbizfanster@gmail.com> wrote:
> 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?

What made you think that?




-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.georgedillon.com/web/html_email_is_evil.shtml
http://www.catb.org/jargon/html/email-style.html


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

Предыдущее
От: john snow
Дата:
Сообщение: why do i get 2 as answer for select length('aa '::char(6));
Следующее
От: john snow
Дата:
Сообщение: Re: why do i get 2 as answer for select length('aa '::char(6));