Received: from dns1.expertiz.com (root@[207.253.141.98]) by hub.org (8.8.8/8.8.8) with ESMTP id KAA15610 for ; Tue, 20 Oct 1998 10:00:25 -0400 (EDT) (envelope-from pascal@expertiz.com) Received: from expertiz.com (pascal@[207.253.141.126]) by dns1.expertiz.com (8.8.7/8.8.7) with ESMTP id KAA09655 for ; Tue, 20 Oct 1998 10:03:31 -0400 Sender: pascal@expertiz.com Message-ID: <362C97AA.52E15EA5@expertiz.com> Date: Tue, 20 Oct 1998 10:01:14 -0400 From: Pascal Forget Organization: Expertiz 3D X-Mailer: Mozilla 4.06 [en] (X11; I; Linux 2.1.123 i586) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Index on VARCHAR faster than TEXT? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, I'd like to know if searches performed on a btree index on a varchar column is faster than an index on a text column. Thanks, Pascal Forget -- Pascal Forget | Expertiz 3D V-P Software Development | 562 Notre-Dame, St-Lambert QC Canada J4P 2K7 email: pascal@expertiz.com | phone: (514) 923-4203 fax: (514) 923-4205