Home > mailing lists

Re: Database design question: ugliness or referential integrity? - Mailing list pgsql-general

From	Jaime Casanova
Subject	Re: Database design question: ugliness or referential integrity?
Date	November 5, 2003 06:46:41
Msg-id	BAY8-F46MTomAoCCCfK0004fef2@hotmail.com Whole thread Raw
In response to	Database design question: ugliness or referential integrity? (Paulo Jan <admin@digital.ddnet.es>)
List	pgsql-general

Tree view

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

pgsql-general by date:

From: Mike Mascari
Date: 05 November 2003, 05:22:14
Subject: Re: access linux command from SQL Query

From: Bjørn T Johansen
Date: 05 November 2003, 08:25:28
Subject: select/update performance?

Re: Database design question: ugliness or referential integrity? - Mailing list pgsql-general

Previous

Next