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(at)commandprompt(dot)com