Re: Unique indicies - Mailing list pgsql-general

From Erik Jones
Subject Re: Unique indicies
Date
Msg-id 6FC17B02-1B56-4473-AAF9-3039EAE26840@myemma.com
Whole thread Raw
In response to Re: Unique indicies  ("Dot Yet" <dot.yet@gmail.com>)
Responses Re: Unique indicies
List pgsql-general
On Feb 22, 2008, at 8:38 AM, Dot Yet wrote:

> that would mean
>
> Every row in foo for column f1 has to be unique
> and
> Every row in foo for column f2 has to be unique

The OP was asking about maintaining normal indexes on each in
addition to the unique index on (f1, f2), not separate unique indexes.

Erik Jones

DBA | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com




pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: text and bytea
Next
From: "A.M."
Date:
Subject: Re: Mac ordering with locales