Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id EB49247675D for ; Tue, 18 Jun 2002 19:22:13 -0400 (EDT) Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (Postfix) with ESMTP id 37C6A476A09 for ; Tue, 18 Jun 2002 18:58:17 -0400 (EDT) Received: from [66.219.92.2] (HELO chocolate-mousse) by davinci.ethosmedia.com (CommuniGate Pro SMTP 3.5.9) with ESMTP id 1532275; Tue, 18 Jun 2002 15:58:18 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: Wei Weng , pgsql-sql@postgresql.org Subject: Re: text vs varchar Date: Tue, 18 Jun 2002 15:59:54 -0700 X-Mailer: KMail [version 1.4] References: <1024438061.16895.2.camel@Monet> In-Reply-To: <1024438061.16895.2.camel@Monet> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200206181559.54654.josh@agliodbs.com> X-Archive-Number: 200206/232 X-Sequence-Number: 8197 Wei, > Is there any disadvantage of using TEXT datatype as opposed to a VARCHAR > datatype with a maximum length, especially when I do searches on them? Yes. You can't index TEXT because it's of potentially unlimited length. --=20 -Josh Berkus