Re: Difference between varchar and text? - Mailing list pgsql-general

From John R Pierce
Subject Re: Difference between varchar and text?
Date
Msg-id 50A89ED3.7050903@hogranch.com
Whole thread Raw
In response to Re: Difference between varchar and text?  (Abel Abraham Camarillo Ojeda <acamari@the00z.org>)
List pgsql-general
On 11/17/12 11:48 PM, Abel Abraham Camarillo Ojeda wrote:
> As far as I know varchar(n) with n being less or equal than 126 cannot be
> toasted, and have only one octet of overhead.
>
> http://www.postgresql.org/docs/9.2/static/storage-toast.html

the same is true for varchar(n) with larger values of N as long as the
actual string in the field is under 126 characeters, and the same is
true for text if the actual string is under 126 characters.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast



pgsql-general by date:

Previous
From: Abel Abraham Camarillo Ojeda
Date:
Subject: Re: Difference between varchar and text?
Next
From: Vincent Veyron
Date:
Subject: Re: user aggregate function ( calculate the average value of each index of an array column )