Dean Rasheed <dean.a.rash...@googlemail.com> writes: > 2009/7/29 Tom Lane <t...@sss.pgh.pa.us>: >> For non-unique indexes, it is not required that <function>aminsert</> >> do anything; it might for instance refuse to index NULLs.
> Doesn't this comment apply equally to unique indexes? Hmm, I was thinking that a unique-capable index would have to index all tuples. But I guess if it's restricted to one index column (like hash) it could omit nulls and still enforce uniqueness correctly. I'll change that comment. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers