about value storage

From: "lsliang" <lsliang(at)pconline(dot)com(dot)cn>
To: "pgsql-docs" <pgsql-docs(at)postgresql(dot)org>
Subject: about value storage
Date: 2011-09-06 02:43:57
Message-ID: 201109061043572514728@pconline.com.cn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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!

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2011-09-06 02:58:57 Re: Add strftime escapes to Log config
Previous Message Alvaro Herrera 2011-09-06 01:07:29 Re: Couple document fixes