Re: partial uniqueness

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: partial uniqueness
Date: 2003-11-23 16:14:29
Message-ID: 20031123161429.GA2612@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Nov 23, 2003 at 04:20:20PM +0100, Karsten Hilbert wrote:
> There recently was a discussion on how to enforce
> uniqueness on a row for a given condition, say allow many
> address rows for a person where active = false but only one
> where active = true. I cannot find it in the archives. Can
> someone please point me to the messages so I can read up ?

You can see a summary here:

www.varlena.com/GeneralBits/51.php

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La Primavera ha venido. Nadie sabe como ha sido" (A. Machado)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Randolf Richardson, DevNet SysOp 29 2003-11-23 16:48:01 Re: Large objects [BLOB] again - general howto
Previous Message Karsten Hilbert 2003-11-23 15:20:20 partial uniqueness