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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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