Re: A modest proposal for a FAQ addition - Mailing list pgsql-hackers

From Tom Lane
Subject Re: A modest proposal for a FAQ addition
Date
Msg-id 28768.1042395308@sss.pgh.pa.us
Whole thread Raw
In response to Re: A modest proposal for a FAQ addition  (Ian Barwick <barwick@gmx.net>)
Responses Re: A modest proposal for a FAQ addition
List pgsql-hackers
Ian Barwick <barwick@gmx.net> writes:
> On Sunday 12 January 2003 17:55, Bruce Momjian wrote:
>> I can't say "don't use CHAR(n)" because there are valid reasons to use
>> it.

> I think what Tom is saying is "always use VARCHAR(n) unless you know
> for sure CHAR(n) is what you want, because if you slept through that part of 
> the SQL course CHAR(n) is not what you might think."

Yes.  It is not clear from either the FAQ or the documentation that
CHAR() should not be one's default choice for a character field.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Ian Barwick
Date:
Subject: Re: A modest proposal for a FAQ addition
Next
From: Peter Eisentraut
Date:
Subject: SQL flagger