maybe I am missing something. Look at this:
CREATE TABLE test (name character(10));
INSERT INTO test VALUES ('test');
SELECT '<' || name || '>' FROM test;
SELECT length(name), name from test;
length | name
4 | test
Should not a char(10) insert 6 padding spaces? Or am I missing something
like an update in the SQL standard?
Sorry if this is an already known issue, I had no time lately to check the
bugs mailing list.
pgsql-bugs by date
|Next:||From: Pawel Bernat||Date: 2005-11-28 16:57:47|
|Subject: Re: Bug on CHARACTER(n) ?|
|Previous:||From: Tom Lane||Date: 2005-11-28 15:20:57|
|Subject: Re: segfault of autovacuum process during restore - coredumps included |