Naz Gassiep <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings