Re: Best way to use indexes for partial match at - Mailing list pgsql-general

Andrus wrote:
> Can Postgres use index
>
> CREATE UNIQUE INDEX foo_bar ON foo(bar bpchar_pattern_ops);
>
> in usual WHERE expressions just like regular index ?
>
> I.e can
>
> SELECT * FROM foo WHERE bar='123'
>
> use index foo_bar ?

I think in the time it took you to write this email you could have typed
in those lines into psql and found out yourself.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/