Received: from golem.jpl.nasa.gov (IDENT:root@hectic-2.jpl.nasa.gov [128.149.68.204]) by hub.org (8.9.1/8.9.1) with ESMTP id PAA11684 for ; Sun, 13 Dec 1998 15:35:32 -0500 (EST) (envelope-from lockhart@alumni.caltech.edu) Received: from alumni.caltech.edu (localhost [127.0.0.1]) by golem.jpl.nasa.gov (8.8.5/8.8.5) with ESMTP id UAA14928; Sun, 13 Dec 1998 20:35:16 GMT Sender: tgl@mythos.jpl.nasa.gov Message-ID: <36742503.1EF0F10B@alumni.caltech.edu> Date: Sun, 13 Dec 1998 20:35:15 +0000 From: "Thomas G. Lockhart" Organization: Caltech/JPL X-Mailer: Mozilla 4.07 [en] (X11; I; Linux 2.0.30 i686) MIME-Version: 1.0 To: Tom Lane CC: Bruce Momjian , pgsql-sql@hub.org Subject: Re: [SQL] char type seems the same as char(1) References: <22059.913569250@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit > > Should I add this to the TODO list, that char is not char1 but has > > 4-byte length? > Well, Tom Lockhart responded that "it's not a bug, it's a feature". > I still think it's broken --- and certainly the fact that quoting > affects the result (char and "char" act differently) is not good. > But the discussion seems to have died out without producing any > definite plan of action. Well, it is a feature, not a bug! Or at least is difficult to get completely and transparently right given both that SQL92 has some specific behaviors required of 'char' and 'char(1)' (they need to be identical) and that we have a historical implementation and usage of 'char' as a one-byte-storage type. But I'm working on reconciling pg_dump with the various ways to input type names, and am looking at fixing code to address the specific bug report regarding DEFAULT clauses. Some fixes will be possible with v6.4.1, with perhaps more complete fixes available in v6.5. Give me a few hours and I'll get back to you. btw, it died out partly because the bug report gave an example (good) but did not give a succinct statement of the problem (bad). I get *way* too much e-mail on the Postgres list and a few others (I lurk on the gnome list because they use the same sgml documentation tools) to catch every report the way I should... - Tom