| 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-05 21:22:54 |
| Message-ID: | 50982E2E.2060704@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 11/05/12 12:46 PM, Moshe Jacobson wrote:
> Is there any practical difference between defining a column as a
> varchar(n) vs. a varchar vs. a text field?
varchar(n) has a length constraint on it. the other two don't.
otherwise all three are identical in implementation.
>
> I've always been under the impression that if I am wanting to index a
> varchar column, it is better to set a maximum length. Is this correct?
no, unless you want to ensure the field will never exceed a specified
length.
> But more importantly, what's the practical difference between varchar
> with no limit and text?
none.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2012-11-05 21:23:48 | Re: Difference between varchar and text? |
| Previous Message | Merlin Moncure | 2012-11-05 21:15:06 | Re: Difference between varchar and text? |