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 support

ashaw@commandprompt.com

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