> 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.