Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id 5CB33475BC0
	for <pgsql-sql@postgresql.org>; Tue, 18 Jun 2002 21:33:34 -0400 (EDT)
Received: from mail.4dmatrix.com (unknown [208.248.151.248])
	by postgresql.org (Postfix) with ESMTP id 9D5B3475928
	for <pgsql-sql@postgresql.org>; Tue, 18 Jun 2002 21:31:25 -0400 (EDT)
Received: from Joshdesk (sonicwall.4dmatrix.com [208.248.151.201] (may be
	forged)) by mail.4dmatrix.com (8.9.3/8.9.3) with SMTP id SAA03745;
	Tue, 18 Jun 2002 18:30:00 -0700
Message-ID: <05e001c21730$ada58490$3e02a8c0@4dmatrix.com>
Reply-To: "Josh Goldberg" <josh@4dmatrix.com>
From: "Josh Goldberg" <josh@4dmatrix.com>
To: <josh@agliodbs.com>, "Wei Weng" <wweng@kencast.com>,
	<pgsql-sql@postgresql.org>
References: <1024438061.16895.2.camel@Monet>
	<200206181559.54654.josh@agliodbs.com>
Subject: Re: text vs varchar
Date: Tue, 18 Jun 2002 18:28:55 -0700
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
X-Archive-Number: 200206/237
X-Sequence-Number: 8202

I have no trouble indexing TEXT datatype in postgres-7.x

----- Original Message ----- 
From: "Josh Berkus" <josh@agliodbs.com>
> Yes.  You can't index TEXT because it's of potentially unlimited length.