Re: Converting MySQL tinyint to PostgreSQL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Converting MySQL tinyint to PostgreSQL
Дата
Msg-id 13061.1121228103@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Converting MySQL tinyint to PostgreSQL  (Greg Stark <gsstark@mit.edu>)
Ответы Re: Converting MySQL tinyint to PostgreSQL  (Dawid Kuroczko <qnex42@gmail.com>)
Список pgsql-general
Greg Stark <gsstark@mit.edu> writes:
> Personally I would settle for a fuller set of small fixed size datatypes. The
> "char" datatype is pretty much exactly what's needed except that it provides
> such a quirky interface.

I'm not actually against inventing an int1/tinyint type.  I used to be
worried that it would screw up the numeric datatype promotion hierarchy
even more than it already was screwed up :-( ... but I think we have
dealt with most of those issues now.  It'd be worth trying anyway ---
much more so than trying to optimize char(1), IMHO.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Converting MySQL tinyint to PostgreSQL
Следующее
От: "Nee.mem(倪明)"
Дата:
Сообщение: How to use rollback in function with 'pgsql'?