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: 6.1.2.0.0.20051128174409.030e4490@pop01.sdb.it (view raw or flat)
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;

  ?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


Responses

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-2014 The PostgreSQL Global Development Group