Home > mailing lists

why do i get 2 as answer for select length('aa '::char(6)); - Mailing list pgsql-novice

From	john snow
Subject	why do i get 2 as answer for select length('aa '::char(6));
Date	January 17, 2018 07:59:57
Msg-id	CAE67tvV20x9GtyPqfZdoK+WxxKYLC3SEjovw+xwGkVKcMqzsow@mail.gmail.com Whole thread Raw
Responses	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));
List	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

From: Purav Chovatia
Date: 16 January 2018, 20:50:55
Subject: symlinks in pg_xlog to wal of previous timeline, after a failover

From: Andrej
Date: 17 January 2018, 08:14:48
Subject: Re: why do i get 2 as answer for select length('aa '::char(6));