Re: [SQL] char type seems the same as char(1) - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: [SQL] char type seems the same as char(1)
Date
Msg-id 199812131931.OAA01559@candle.pha.pa.us
Whole thread Raw
In response to Re: [SQL] char type seems the same as char(1)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
> Bruce Momjian <maillist@candle.pha.pa.us> writes:
> > 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.

If we use char1 for internal tables, we should allow it externally, if
only as char1.  I will add it to the TODO list.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] char type seems the same as char(1)
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [SQL] char type seems the same as char(1)