Re: Difference between varchar and text?

On 11/17/12 5:37 PM, David Johnston wrote:
> 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
sameunderlying implementation.  What makes you think differently? 

I think he meant a tiny tiny bit faster, primarily due to not having to
validate the length.


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