when to use char, varchar or text - Mailing list pgsql-novice

From Rory Campbell-Lange
Subject when to use char, varchar or text
Date
Msg-id 20020523120439.GA13898@campbell-lange.net
Whole thread Raw
Responses Re: when to use char, varchar or text  ("Joshua b. Jore" <josh@greentechnologist.org>)
Re: when to use char, varchar or text  ("Adam Erickson" <adamre@cox.net>)
List 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 by date:

Previous
From: "Pierre-Alexis PAQUIN"
Date:
Subject: I WANT TO UNSUBSCRIBE
Next
From: "Joshua b. Jore"
Date:
Subject: Re: when to use char, varchar or text