Re: Database design question: ugliness or referential integrity?

From: "Jaime Casanova" <el_vigia_ec(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Database design question: ugliness or referential integrity?
Date: 2003-11-05 07:46:09
Message-ID: BAY8-F46MTomAoCCCfK0004fef2@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

One solution is to create partial index:

create unique index indice on emails(direccion) where estado = 'A'

_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus

Browse pgsql-general by date

  From Date Subject
Next Message Bjørn T Johansen 2003-11-05 09:24:51 select/update performance?
Previous Message Mike Mascari 2003-11-05 06:20:22 Re: access linux command from SQL Query