Re: Difference between varchar and text?

From: David Johnston <polobo(at)yahoo(dot)com>
To: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Difference between varchar and text?
Date: 2012-11-18 01:37:34
Message-ID: 4BA24337-6353-426D-B740-F805E3C2331A@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Nov 17, 2012, at 20:11, Jasen Betts <jasen(at)xnet(dot)co(dot)nz> wrote:

> On 2012-11-05, Moshe Jacobson <moshe(at)neadwerx(dot)com> wrote:
>
>> But more importantly, what's the practical difference between varchar with
>> no limit and text?
>
> text is immeasurably faster.
>
>>

If it cannot be measured then how can you claim this?

Everything I've heard says there is no difference between "varchar" and "text" as they are simply synonyms for the same underlying implementation. What makes you think differently?

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jasen Betts 2012-11-18 01:41:12 Re: Exclusion constraints with time expressions
Previous Message Jasen Betts 2012-11-18 01:11:53 Re: Difference between varchar and text?