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 по дате отправления: