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