Postgres Pro
Downloads
Home   >   mailing lists

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

From Andrej
Subject Re: why do i get 2 as answer for select length('aa '::char(6));
Date
Msg-id CACMx3pP_6rX1YLJCDC4UR7d4JWtbuBZa=D47o16E9=aABpLLSQ@mail.gmail.com
Whole thread Raw
In response to why do i get 2 as answer for select length('aa '::char(6));  (john snow <ofbizfanster@gmail.com>)
Responses Re: why do i get 2 as answer for select length('aa '::char(6));
List pgsql-novice
Tree view 
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 by date:

Previous
From: john snow
Date:
Subject: why do i get 2 as answer for select length('aa '::char(6));
Next
From: john snow
Date:
Subject: Re: why do i get 2 as answer for select length('aa '::char(6));