On Wed, Dec 4, 2013 at 12:18 PM, Andrew Dunstan <and...@dunslane.net> wrote: >> Interestingly, the variant for which you can't think of a use case is >> the one I've missed most. Typical examples in my experience are >> things like project.project_manager_id references person (id) where >> person.is_project_manager, or alert (device_id) references device (id) >> where not device.deleted. >> > OK, those make sense. I wonder whether this should be done via a USING > clause on the constraint that pointed to the partial unique index. Or would > that be too obscure?
I wondered that, too. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
