Re: [HACKERS] varchar/char size - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] varchar/char size
Date
Msg-id 199801072304.SAA07589@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] varchar/char size  (The Hermit Hacker <scrappy@hub.org>)
List 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

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: varchar
Next
From: Bruce Momjian
Date:
Subject: rollback varchar change