Skip site navigation (1) Skip section navigation (2)

Re: Disadvantages to using "text"

From: Bruce Hyatt <brucejhyatt(at)yahoo(dot)com>
To: Aurynn Shaw <ashaw(at)commandprompt(dot)com>, "Don Mies \(NIM\)" <dmies(at)networksinmotion(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Disadvantages to using "text"
Date: 2008-05-07 16:44:10
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
--- Aurynn Shaw <ashaw(at)commandprompt(dot)com> wrote:
> Internally, Postgres treats a VARCHAR(n) as a TEXT with a
> constraint applied to it, so VARCHAR is going to be slightly
> slower to use.

VARCHAR is slower too? There's no check on VARCHAR, is there?


Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

In response to


pgsql-novice by date

Next:From: Tom LaneDate: 2008-05-07 16:54:51
Subject: Re: Disadvantages to using "text"
Previous:From: Tom LaneDate: 2008-05-07 16:09:27
Subject: Re: Disadvantages to using "text"

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group