best index for ~ ordering?

From: Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar>
To: pgsql-sql(at)postgresql(dot)org
Subject: best index for ~ ordering?
Date: 2007-03-06 21:34:23
Message-ID: 45EDDE5F.2030303@fmed.uba.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all, i have a large table with one varchar field, and im triyng to
get information about what index should i use in order to using that
index (if this is possible) for ~ searching, and/or using LIKE searching.

Thanks!
Gerardo

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Sullivan 2007-03-06 22:28:02 Re: best index for ~ ordering?
Previous Message Ezequias Rodrigues da Rocha 2007-03-06 19:09:34 Re: Inc