Received: from gandalf.sd.spardat.at (gandalf.telecom.at [194.118.26.84]) by hub.org (8.8.8/8.7.5) with ESMTP id EAA06169 for ; Wed, 25 Mar 1998 04:02:00 -0500 (EST) Received: from pc9358.sd.spardat.at (zeugswettera.user.lan.at [10.4.133.132]) by gandalf.sd.spardat.at (8.8.8/8.8.8) with SMTP id KAA40044; Wed, 25 Mar 1998 10:01:37 +0100 Received: by pc9358.sd.spardat.at with Microsoft Mail id <01BD57D5.010B24C0@pc9358.sd.spardat.at>; Wed, 25 Mar 1998 10:01:39 +-100 Message-ID: <01BD57D5.010B24C0@pc9358.sd.spardat.at> From: Zeugswetter Andreas To: "'Bruce Momjian'" Cc: "'pgsql-hackers@hub.org'" Subject: Re: [HACKERS] char types gone. Date: Wed, 25 Mar 1998 10:01:33 +-100 Encoding: 28 TEXT Bruce wrote: >> >> You seem to be getting me wrong, right from the start. I appreciate your work on removing >> char2-char16. I also think it is the correct step. You have the hackers behind you, the discussion was >> about 2 - 3 weeks ago. I was part of it. There are three things that will need documentation: >> 1. the replacement for char16 is char(16) >> 2. char(16) gives and ignores trailing blanks > >I don't think this is true. Hmm ? I am puzzeled. Of course this is true, it has to be, it is standard: test=> create table chartest (a char(16)); test=> insert into chartest values ('Andreas'); test=> select a || '<' from chartest; ?column? ----------------- Andreas < (1 row) test=> select a || '<' from chartest where a='Andreas'; ?column? ----------------- Andreas < (1 row) Andreas