Re: about value storage

"lsliang" <lsliang@pconline.com.cn> writes:
> http://www.postgresql.org/docs/9.0/interactive/typeconv-query.html
> example shows:

> CREATE TABLE vv (v character(20));
> INSERT INTO vv SELECT 'abc' || 'def';
> SELECT v, length(v) FROM vv;

>           v           | length
> ----------------------+--------
>  abcdef               |     20
> (1 row)

> but  my test show not like this :

Hmm, looks like that example was overlooked when we changed the behavior
years ago:
http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=f27976c85b1fb9002727cce65b9f9567e158f754

Given the context, we should change it to use octet_length().
Will fix, thanks.

            regards, tom lane