Re: pgsql: doc: add examples of creative use of unique expression indexes

Bruce Momjian <bruce(at)momjian(dot)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