Re: Unique indicies

Naz Gassiep <naz@mira.net> writes:
> If you have an index like this:
> CREATE UNIQUE INDEX foo ON tablename (f1, f2);

> Is there any value in having independent indicies on f1 and f2 as well
> or are they unnecessary?

See
http://www.postgresql.org/docs/8.3/static/indexes.html
particularly sections 11.3 and 11.5

            regards, tom lane