Re: Disadvantages to using "text"

Frank Bax wrote:
> Aurynn Shaw 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.
> 
> 
> Don't you mean VARCHAR(n) will be slightly slower on UPDATES.

Yes, that is what I meant. Thank you. :)

-- 
Aurynn Shaw

The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 ext 103
PostgreSQL Replication, Consulting, Custom Development, 24x7 sup****t

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