From: Thomas G. Lockhart <lockhart@alumni.caltech.edu>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Bruce Momjian <maillist@candle.pha.pa.us>
Cc: pgsql-sql@hub.org
Subject: Re: [SQL] char type seems the same as char(1)
Date: Sun, 13 Dec 1998 20:35:15 +0000
Message-ID: <36742503.1EF0F10B@alumni.caltech.edu> (raw)
References: <22059.913569250@sss.pgh.pa.us>
> > 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: lockhart@alumni.caltech.edu, tgl@sss.pgh.pa.us, maillist@candle.pha.pa.us, pgsql-sql@hub.org
Subject: Re: [SQL] char type seems the same as char(1)
In-Reply-To: <36742503.1EF0F10B@alumni.caltech.edu>
References: <22059.913569250@sss.pgh.pa.us> <36742503.1EF0F10B@alumni.caltech.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox