Index on VARCHAR faster than TEXT?

From: Pascal Forget <pascal(at)expertiz(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Index on VARCHAR faster than TEXT?
Date: 1998-10-20 14:01:14
Message-ID: 362C97AA.52E15EA5@expertiz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)expertiz(dot)com | phone: (514) 923-4203 fax: (514) 923-4205

Browse pgsql-sql by date

  From Date Subject
Next Message Jackson, DeJuan 1998-10-20 14:46:03 RE: [SQL] timespan question: using value from row in select
Previous Message Michael Olivier 1998-10-20 01:18:12 timespan question: using value from row in select