nulls in GIN index - Mailing list pgsql-hackers

From worthy7
Subject nulls in GIN index
Date
Msg-id 1407709189891-5814384.post@n5.nabble.com
Whole thread Raw
Responses Re: nulls in GIN index
List 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.



pgsql-hackers by date:

Previous
From: Noah Misch
Date:
Subject: Re: Partitioning performance: cache stringToNode() of pg_constraint.ccbin
Next
From: Noah Misch
Date:
Subject: Re: Proposal to add a QNX 6.5 port to PostgreSQL