when to use char, varchar or text

Поиск
Список
Период
Сортировка
От Rory Campbell-Lange
Тема when to use char, varchar or text
Дата
Msg-id 20020523120439.GA13898@campbell-lange.net
обсуждение исходный текст
Ответы Re: when to use char, varchar or text
Re: when to use char, varchar or text
Список pgsql-novice
I'm making a table to hold a queue of incoming and outgoing email
messages. I'm confused about using char, varchar or text fields - I
imagine they are searchable (without and index) with decreasing speed
from char to text. Is that right?

The (very simplified) column setup I have includes:
    to            varchar(200)
    from          varchar(200)
    cc              varchar(200)
    subject          text
    body          text

Should I make the columns all of type text so that large numbers of 'to'
recipients can be supported?

Some general advice greatly appreciated.

p.s. I expect the number of rows in this table to be less than 5000.

--
Rory Campbell-Lange
<rory@campbell-lange.net>
<www.campbell-lange.net>

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

Предыдущее
От: "Pierre-Alexis PAQUIN"
Дата:
Сообщение: I WANT TO UNSUBSCRIBE
Следующее
От: "Joshua b. Jore"
Дата:
Сообщение: Re: when to use char, varchar or text