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@sss.pgh.pa.us> wrote:
john snow <ofbizfanster@gmail.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.
