Re: Unique indicies

From: Erik Jones <erik(at)myemma(dot)com>
To: Dot Yet <dot(dot)yet(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unique indicies
Date: 2008-02-22 15:35:14
Message-ID: 6FC17B02-1B56-4473-AAF9-3039EAE26840@myemma.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)myemma(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hernan gonzalez 2008-02-22 15:54:46 Re: text and bytea
Previous Message Martijn van Oosterhout 2008-02-22 15:33:50 Re: text and bytea