On 11/20/18 9:59 AM, Tom Lane wrote: > "Jonathan S. Katz" <jk...@postgresql.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
signature.asc
Description: OpenPGP digital signature