text vs. varchar

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: text vs. varchar
Date: 2010-07-21 15:58:54
Message-ID: 053345DC-DBFB-44E9-9E37-CAABC13A539C@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2010-07-21 16:04:21 Re: text vs. varchar
Previous Message Joe Conway 2010-07-21 15:43:34 Re: locating cities within a radius of another