Re: Difference between varchar and text?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Difference between varchar and text?
Date: 2012-11-18 08:39:47
Message-ID: 50A89ED3.7050903@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vincent Veyron 2012-11-18 09:21:17 Re: user aggregate function ( calculate the average value of each index of an array column )
Previous Message Abel Abraham Camarillo Ojeda 2012-11-18 07:48:39 Re: Difference between varchar and text?