From: lsliang <lsliang@pconline.com.cn>
To: pgsql-docs <pgsql-docs@postgresql.org>
Subject: about value storage
Date: Tue, 6 Sep 2011 10:43:57 +0800
Message-ID: <201109061043572514728@pconline.com.cn> (raw)
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 instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: lsliang@pconline.com.cn
Subject: Re: about value storage
In-Reply-To: <201109061043572514728@pconline.com.cn>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox