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

From Aurynn Shaw
Subject Re: Disadvantages to using "text"
Date
Msg-id 482200D3.4050007@commandprompt.com
Whole thread Raw
In response to Re: Disadvantages to using "text"  (Frank Bax <fbax@sympatico.ca>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: "Obe, Regina"
Date:
Subject: Re: Disadvantages to using "text"
Next
From: Bruce Hyatt
Date:
Subject: Re: Disadvantages to using "text"