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

From David Johnston
Subject Re: Difference between varchar and text?
Date
Msg-id 4BA24337-6353-426D-B740-F805E3C2331A@yahoo.com
Whole thread Raw
In response to Re: Difference between varchar and text?  (Jasen Betts <jasen@xnet.co.nz>)
Responses Re: Difference between varchar and text?
List pgsql-general
On Nov 17, 2012, at 20:11, Jasen Betts <jasen@xnet.co.nz> wrote:

> On 2012-11-05, Moshe Jacobson <moshe@neadwerx.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
underlyingimplementation.  What makes you think differently? 

David J.

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Difference between varchar and text?
Next
From: John R Pierce
Date:
Subject: Re: Difference between varchar and text?