Bruce Momjian <bruce@momjian.us> writes:
> I agree with your analysis. I still want to have some mention that
> partial indexes can be used to create single-NULL columns, which might
> be required for compatibility with other databases. Attached is an
> updated patch which removes the previous commit but adds a mention of
> this.
The single-null thing is probably a useful example, but please make
it an actual separate example, or at least its own para outside the
existing <example> sections.
Also, the existing example demonstrating that seems overcomplicated;
why not just
create unique index ... (1) where (foo is null);
regards, tom lane