Unique indicies

From: Naz Gassiep <naz(at)mira(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Unique indicies
Date: 2008-02-22 11:53:32
Message-ID: 47BEB7BC.9030008@mira.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks
- Naz.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Davies 2008-02-22 12:09:11 Re: ts_headline
Previous Message Howard Wilkinson 2008-02-22 11:38:33 Re: Querying the schema for column widths - what syntax do I use?