Re: join on a like

From: "mlartz(at)gmail(dot)com" <mlartz(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: join on a like
Date: 2006-05-01 11:45:11
Message-ID: 1146483911.614478.77500@u72g2000cwu.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

If you use a btree index on the column, you should be able to use it in
the like:
http://www.postgresql.org/docs/8.1/interactive/indexes-types.html.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Oleg Bartunov 2006-05-01 12:55:46 Re: Like with special character
Previous Message Sim Zacks 2006-05-01 10:14:21 join on a like