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

From:	john snow <ofbizfanster(at)gmail(dot)com>
To:	pgsql-novice(at)postgresql(dot)org
Subject:	why do i get 2 as answer for select length('aa '::char(6));
Date:	2018-01-17 01:59:57
Message-ID:	CAE67tvV20x9GtyPqfZdoK+WxxKYLC3SEjovw+xwGkVKcMqzsow@mail.gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2018-01-17 01:59:57 from john snow <ofbizfanster(at)gmail(dot)com>  2018-01-17 02:14:48 from Andrej <andrej(dot)groups(at)gmail(dot)com>   2018-01-17 02:40:50 from john snow <ofbizfanster(at)gmail(dot)com>  2018-01-17 02:52:23 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>   2018-01-17 03:03:24 from john snow <ofbizfanster(at)gmail(dot)com>  2018-01-17 03:09:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2018-01-17 03:23:13 from john snow <ofbizfanster(at)gmail(dot)com>    2018-01-17 03:32:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2018-01-17 03:37:43 from john snow <ofbizfanster(at)gmail(dot)com>      2018-01-17 08:10:21 from RABIN NATHAN <r_nathan(at)shaw(dot)ca>
Lists:	pgsql-novice

Responses

• Re: why do i get 2 as answer for select length('aa '::char(6)); at 2018-01-17 02:14:48 from Andrej
• Re: why do i get 2 as answer for select length('aa '::char(6)); at 2018-01-17 02:52:23 from David G. Johnston
• Re: why do i get 2 as answer for select length('aa '::char(6)); at 2018-01-17 03:09:16 from Tom Lane

Browse pgsql-novice by date

	From	Date	Subject
Next Message	Andrej	2018-01-17 02:14:48	Re: why do i get 2 as answer for select length('aa '::char(6));
Previous Message	Purav Chovatia	2018-01-16 14:50:55	symlinks in pg_xlog to wal of previous timeline, after a failover