By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,692 Members | 1,998 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,692 IT Pros & Developers. It's quick & easy.

partial uniqueness

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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)

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.