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: 387916.1526.qm@web34403.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
--- Aurynn Shaw <ashaw(at)commandprompt(dot)com> wrote:
> Internally, Postgres treats a VARCHAR(n) as a TEXT with a
> CHECK 
> 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?

Bruce


      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

In response to

Responses

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-2014 The PostgreSQL Global Development Group