Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: varchar(n) VS text
- From: Ben <bench(at)silentmedia(dot)com>
- To: Pierre Thibaudeau <pierdeux(at)gmail(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: varchar(n) VS text
- Date: Mon, 25 Jun 2007 21:06:34 -0700 (PDT)
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.
- References:
- varchar(n) VS text
- From: Pierre Thibaudeau
- varchar(n) VS text
- Prev by Date: varchar(n) VS text
- Next by Date: Re: varchar(n) VS text
- Previous by thread: varchar(n) VS text
- Next by thread: Re: varchar(n) VS text
- Indexes: