Re: varchar(n) VS text - Mailing list pgsql-general

From Ben
Subject Re: varchar(n) VS text
Date
Msg-id Pine.LNX.4.64.0706252105010.27105@localhost.localdomain
Whole thread Raw
In response to varchar(n) VS text  ("Pierre Thibaudeau" <pierdeux@gmail.com>)
List pgsql-general
On Mon, 25 Jun 2007, Pierre Thibaudeau wrote:

> From my reading of the dataype documentation, the ONLY reason I can
> think of for using "varchar(n)" would be in order to add an extra
> data-type constraint to the column.

That's my understanding as well. I can think of a few reasons to use
char(n) over text if you know exactly how many characters you will always
have, but char isn't what you asked about.

pgsql-general by date:

Previous
From: "Pierre Thibaudeau"
Date:
Subject: varchar(n) VS text
Next
From: Tom Lane
Date:
Subject: Re: varchar(n) VS text