Postgres Pro
Downloads
Home   >   mailing lists

Re: Disadvantages to using "text" - Mailing list pgsql-novice

From Bruce Hyatt
Subject Re: Disadvantages to using "text"
Date
Msg-id 387916.1526.qm@web34403.mail.mud.yahoo.com
Whole thread Raw
In response to Re: Disadvantages to using "text"  (Aurynn Shaw <ashaw@commandprompt.com>)
Responses Re: Disadvantages to using "text"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view 
--- Aurynn Shaw <ashaw@commandprompt.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

pgsql-novice by date:

Previous
From: Aurynn Shaw
Date:
Subject: Re: Disadvantages to using "text"
Next
From: Tom Lane
Date:
Subject: Re: Disadvantages to using "text"