creating indexes on character fields - Mailing list pgsql-sql

From Eric Enockson
Subject creating indexes on character fields
Date
Msg-id 37D3D6A8.E83703E5@cloudband.com
Whole thread Raw
List pgsql-sql
    i have a person here who is telling me that i should not create
indexes
on character fields.  That is a

index_field char(32)

or something.
  This doesn't make sense to me because it seems that we can order
strings
as easily as ordering numbers as they're all just binary to the computer

anyway.
   He is saying bascially that this bit off code from my sql book is
something he has never seen done in a database in his life.  I do not
understand.
   Create INDEX author_name   on books (author_name)




pgsql-sql by date:

Previous
From: "Åíΰ³É"
Date:
Subject:
Next
From: Herouth Maoz
Date:
Subject: Re: [SQL] indexes using datetime