Postgres Pro
Downloads
Home   >   mailing lists

Data type recommendation - Mailing list pgsql-general

From Thomas Lim
Subject Data type recommendation
Date
Msg-id 37A7F38E.8C5E4D67@pc.jaring.my
Whole thread Raw
Responses Re: [GENERAL] Data type recommendation
List pgsql-general
Tree view 
According to the user guide, it is mentioned that TEXT data type is
recommended over CHAR or VARCHAR.  Does anyone know why?  I thought the
access time for TEXT is slower.  Shouldn't CHAR be used for key fields?
Is there some sort of overheads for CHAR or VARCHAR that TEXT is
recommended?  Hope that someone has an answer to this recommendation.

Thanks,
Thomas Lim.

pgsql-general by date:

Previous
From: "Dan Wilson"
Date:
Subject: Re: [GENERAL] Query buffer problem.
Next
From: Ramanika
Date:
Subject: sequence not reliable?