Re: Disadvantages to using "text"

by brucejhyatt@[EMAIL PROTECTED] (Bruce Hyatt) May 7, 2008 at 09:44 AM

--- Aurynn Shaw <ashaw@[EMAIL PROTECTED]
> 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

-- 
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

15 Posts in Topic:

Disadvantages to using "text"

dmies@[EMAIL PROTECTED]

2008-05-07 08:52:27

Re: Disadvantages to using "text"

rdeleonp@[EMAIL PROTECTED

2008-05-07 11:01:09

Re: Disadvantages to using "text"

richard.broersma@[EMAIL P

2008-05-07 09:03:57

Re: Disadvantages to using "text"

tgl@[EMAIL PROTECTED] (T