Question: Deferred Unique Constraint using Function-based Index

I’ve raised this question on stackoverflow – anyone have any ideas?

Deferred Unique Constraint using a Function-based Index?

UPDATE: Thanks Gary for the answer!

Handling unique constraint violations by Hibernate
Question: why can’t the optimizer do better with these?

Comments

  1. Posted another approach on Stackoverflow (which I believe is answer if I have understood your question correctly)

Leave a Reply

Your email address will not be published / Required fields are marked *