Re: Best way to use indexes for partial match at

["Andrus" <eetasoft@xxxxxxxxx>]

> Note that if you don't use the pk in unnamed joins (i.e. you always
> identify the field you're keying off of) then the primary key is
> redundant and not needed, and you could just create the table without it
> and then create the unique index.

Thank you.
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 ?

Andrus. 



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend