Postgres Pro
Downloads
Home   >   mailing lists

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

From Frank Bax
Subject Re: Disadvantages to using "text"
Date
Msg-id 4821DEF2.8070405@sympatico.ca
Whole thread Raw
In response to Re: Disadvantages to using "text"  (Aurynn Shaw <ashaw@commandprompt.com>)
Responses Re: Disadvantages to using "text"
Re: Disadvantages to using "text"
List pgsql-novice
Tree view 
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.

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Disadvantages to using "text"
Next
From: "Greg Cocks"
Date:
Subject: Re: Disadvantages to using "text"