Re: Fixed chars

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Fixed chars
Date: 2018-03-28 09:32:39
Message-ID: f692c85d-4c64-d94b-ed35-cf2b0799bf0e@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am 28.03.2018 um 11:11 schrieb Enrico Pirozzi:
> Hi , I've seen this strange thing.
>
> sitedb=# create table test_tb(codice char(7));
> CREATE TABLE
> sitedb=# insert into test_tb values('pippo');
> INSERT 0 1
> sitedb=# select codice || 'a'::char(1),length(codice) from test_tb
>  ?column? | length
> ----------+--------
>  pippoa   |      5
> (1 row)
>

where is the problem? length() returns the number of chars in string,
and the string in codice is 5 chars long.

>
> On the official documentation
>
> |character(/|n|/)|,|char(/|n|/)|     fixed-length, blank padded
>
> https://www.postgresql.org/docs/10/static/datatype-character.html

test=*# select length('12345'::char(10)), pg_column_size('12345'::char(10));
 length | pg_column_size
--------+----------------
      5 |             14
(1 Zeile)

helps that?

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

In response to

  • Fixed chars at 2018-03-28 09:11:53 from Enrico Pirozzi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Enrico Pirozzi 2018-03-28 09:53:17 Re: Fixed chars
Previous Message Enrico Pirozzi 2018-03-28 09:11:53 Fixed chars