On Tue, 12 Feb 2002, Singer Wang wrote:
> if I have a column that's gonna be between 5-300 charactors... should I go with a
> a charactor? varchar? or a text?
>
> what's the performance penalty going with a text instead of a varchar... or a char?
> I don't need to index it.... nor search based on it..
I'd go with text. It's not SQL92, though. varchar is technically
supposed to have a limit of 255, but I don't think that limit
exists in Postgres.
-- Brett
http://www.chapelperilous.net/
------------------------------------------------------------------------
To say you got a vote of confidence would be to say you needed a vote of
confidence.
-- Andrew Young