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 :

               ^
lsl=# select version();
                                                      version                   
                                   
-------------------------------------------------------------------------------------------------------------------
 PostgreSQL 9.0.1 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 
20080704 (Red Hat 4.1.2-46), 64-bit
(1 row)

lsl=# CREATE TABLE vv (v character(20));
INSERT INTO vv SELECT 'abc' || 'def';
SELECT v, length(v) FROM vv;
CREATE TABLE
lsl=# INSERT INTO vv SELECT 'abc' || 'def';
INSERT 0 1
lsl=# SELECT v, length(v) FROM vv;
          v           | length 
----------------------+--------
 abcdef               |      6
(1 row)


why ??   anyone  help me ? 

or  it is a  doc mistake ? 

thank you! 

Reply via email to