Re: Difference between varchar and text?

On Nov 17, 2012, at 20:43, John R Pierce <pierce(at)hogranch(dot)com> wrote:

> On 11/17/12 5:37 PM, David Johnston wrote:
>> 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?
>
> I think he meant a tiny tiny bit faster, primarily due to not having to validate the length.
>
Maybe... But I would presume a "varchar with no limit" does not validate length...