Re: Unique functional index and FK constraints - Mailing list pgsql-hackers

Kris Jurka <jurka@ejurka.com> writes:
> When you restructured the unique index location and validation for
> foreign key constraints around 9/22 you added the restriction that the
> supporting unique index may not be functional.  I believe that this
> restriction is not necessary.

Hmm ... I'm not convinced.  What about functions that return NULL for
some inputs?  A unique index will not reject multiple NULL entries.
        regards, tom lane