| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| 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:21 |
| Message-ID: | 1279728261.22360.0.camel@jd-desktop.unknown.charter.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2010-07-21 at 08:58 -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.
They are the same thing. So is varchar(n) it just has a length
constraint.
JD
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pierre Racine | 2010-07-21 16:04:23 | Re: locating cities within a radius of another |
| Previous Message | Ben Chobot | 2010-07-21 15:58:54 | text vs. varchar |