About column type to "varchar(1)" or "char(1)"

Поиск
Список
Период
Сортировка
От Emi Lu
Тема About column type to "varchar(1)" or "char(1)"
Дата
Msg-id 430CC52A.6080001@cs.concordia.ca
обсуждение исходный текст
Ответы Re: About column type to "varchar(1)" or "char(1)"  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
Good afternoon,

A question about varchar(1) and char(1).
If we have two tables
test1 (col1 varchar(1), ... ... );
test2 (col1 char(1), ... ... );

In the manuall, it written:

*Tip: * There are no performance differences between these three types,
apart from the increased storage size when using the blank-padded type.
While character(/n/) has performance advantages in some other database
systems, it has no such advantages in PostgreSQL. In most situations
text or character varying should be used instead.

As a result, setup 'col1' to either "varchar(1)" or "char(1)" does not
matter at all?

Thanks a lot,
Emi

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

Предыдущее
От: "Welty, Richard"
Дата:
Сообщение: Re: Postgresql replication
Следующее
От: "Dann Corbit"
Дата:
Сообщение: Re: My Slow query.