Skip site navigation (1) Skip section navigation (2)

Bug on CHARACTER(n) ?

From: Stefano Reksten <sreksten(at)sdb(dot)it>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug on CHARACTER(n) ?
Date: 2005-11-28 16:49:02
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
Hello list,
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 BernatDate: 2005-11-28 16:57:47
Subject: Re: Bug on CHARACTER(n) ?
Previous:From: Tom LaneDate: 2005-11-28 15:20:57
Subject: Re: segfault of autovacuum process during restore - coredumps included

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group