Re: [HACKERS] varchar/char size

Bruce Momjian <maillist@candle.pha.pa.us>

From: Bruce Momjian <maillist@candle.pha.pa.us>
To: scrappy@hub.org (The Hermit Hacker)
Cc: hackers@postgreSQL.org
Date: 1998-01-07T23:04:08Z
Lists: pgsql-hackers
> 
> On Wed, 7 Jan 1998, Bruce Momjian wrote:
> 
> > In my experience, char() is full size as defined by create, and
> > varchar() is the the size of the actual data in the field, like text,
> > but with a pre-defined limit.
> 
> 	Can you remind me what the difference is between text and varchar?  Why
> would you use varchar over text?

Only because SQL people are used to varchar, and not text, and sometimes
people want to have a maximum size if they are displaying this data in a
form that is only of limited size.

-- 
Bruce Momjian
maillist@candle.pha.pa.us