nulls in GIN index

From: worthy7 <worthy(dot)vii(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: nulls in GIN index
Date: 2014-08-10 22:19:49
Message-ID: 1407709189891-5814384.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


http://www.postgresql.org/docs/9.1/static/gin-implementation.html
"""As of PostgreSQL 9.1, NULL key values can be included in the index. Also,
placeholder NULLs are included in the index for indexed items that are NULL
or contain no keys according to extractValue. This allows searches that
should find empty items to do so."""

How do I define an index that includes nulls then?

--
View this message in context: http://postgresql.1045698.n5.nabble.com/nulls-in-GIN-index-tp5814384.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Noah Misch 2014-08-10 22:36:18 Re: Proposal to add a QNX 6.5 port to PostgreSQL
Previous Message Noah Misch 2014-08-10 21:35:30 Re: Partitioning performance: cache stringToNode() of pg_constraint.ccbin