| 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 01:43:07 |
| Message-ID: | 50A83D2B.8090806@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Johnston | 2012-11-18 01:49:07 | Re: Difference between varchar and text? |
| Previous Message | Jasen Betts | 2012-11-18 01:41:12 | Re: Exclusion constraints with time expressions |