| From: | "Peter C(dot) Lai" <peter(at)simons-rock(dot)edu> |
|---|---|
| To: | Ben Chobot <bench(at)silentmedia(dot)com> |
| Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: text vs. varchar |
| Date: | 2010-07-21 16:04:48 |
| Message-ID: | 20100721160447.GD35187@cesium.hyperfine.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
varchar allows you to define an explicit length of the field, text does not.
varchar with a length specified (varchar(n)) is sql92 compliant while
varchar() and text are pgsql extensions.
On 2010-07-21 08:58:54AM -0700, Ben Chobot wrote:
> Is there any difference between "text" and "varchar" data types? (Not varchar(n), just varchar.) I can't see a different from the manual page, but I'm wondering about index usage or something similarly subtle.
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
--
===========================================================
Peter C. Lai | Bard College at Simon's Rock
Systems Administrator | 84 Alford Rd.
Information Technology Svcs. | Gt. Barrington, MA 01230 USA
peter AT simons-rock.edu | (413) 528-7428
===========================================================
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thom Brown | 2010-07-21 16:05:00 | Re: text vs. varchar |
| Previous Message | Pierre Racine | 2010-07-21 16:04:23 | Re: locating cities within a radius of another |