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!
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 |