Postgres Pro
Downloads
Home   >   mailing lists

Index on VARCHAR faster than TEXT? - Mailing list pgsql-sql

From Pascal Forget
Subject Index on VARCHAR faster than TEXT?
Date
Msg-id 362C97AA.52E15EA5@expertiz.com
Whole thread Raw
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Michael Olivier
Date:
Subject: timespan question: using value from row in select
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: [SQL] timespan question: using value from row in select