partial uniqueness

[Karsten Hilbert]

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 ?
Thanks. Also I can't find the relevant section in Celko's SQL
for Smarties anymore :-(( I know it's in there, I did see it
before...

I am trying to do it with triggers and a partial index
but can't seem to get there.

Can post details if wanted.

Thanks again,
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Alvaro Herrera]

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)

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)