Bug on CHARACTER(n) ? - Mailing list pgsql-bugs

From Stefano Reksten
Subject Bug on CHARACTER(n) ?
Date
Msg-id 6.1.2.0.0.20051128174409.030e4490@pop01.sdb.it
Whole thread Raw
Responses Re: Bug on CHARACTER(n) ?
Re: Bug on CHARACTER(n) ?
Re: Bug on CHARACTER(n) ?
List 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;

  ?column?
----------
  <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.

Ciao,
   Stefano

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: segfault of autovacuum process during restore - coredumps included
Next
From: Pawel Bernat
Date:
Subject: Re: Bug on CHARACTER(n) ?