Re: Documentation for create unique index is insuficient and (because of that) incorrect

On 11/20/18 9:59 AM, Tom Lane wrote:
> "Jonathan S. Katz" <jkatz(at)postgresql(dot)org> writes:
>> On 11/19/18 9:05 PM, Bruce Momjian wrote:
>>> On Tue, Oct 23, 2018 at 06:29:55PM +0000, PG Doc comments form wrote:
>>>> In https://www.postgresql.org/docs/11/static/indexes-unique.html there are
>>>> omited clausules
>
>>> The first URL is an example and is not intended to be the complete
>>> syntax.
>
>> In fairness, the "INCLUDE" clause was added, which is new to PostgreSQL
>> 11, so it could raise the question as to why aren't other clauses there.
>
> Yes. That was a dumb idea; the correct fix is to take that out, because
> it's not appropriate here. There might be room for an additional section
> later in the chapter that discusses INCLUDE, but we shouldn't be
> cluttering the discussion of fundamental concepts like unique indexes
> with that.

Shows how closely I read the docs. +1 on removing INCLUDE from UNIQUE
indexes.

Also +1 on having a section on covering indexes.

Jonathan