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

when you say char-type values, do you include varchar? if so, the other
results (see later post from first post) i get are inconsistent with the
assertion that length() disregards trailing spaces in char-type values, and
i don't understand why it's inconsistent. i hope i'm not becoming annoying
:-)

On Wed, Jan 17, 2018 at 11:09 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> john snow <ofbizfanster(at)gmail(dot)com> writes:
> > 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?
>
> It *is* padded, as you can verify with other functions such as
> octet_length or pg_column_size. But length() disregards trailing
> spaces in char-type values, on the theory that they're semantically
> insignificant.
>
> regards, tom lane
>