Re: [SQL] char type seems the same as char(1)

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [SQL] char type seems the same as char(1)
Дата
Msg-id 199812131931.OAA01559@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [SQL] char type seems the same as char(1)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] char type seems the same as char(1)
Следующее
От: "Thomas G. Lockhart"
Дата:
Сообщение: Re: [SQL] char type seems the same as char(1)