On 08/11/2014 01:19 AM, worthy7 wrote:

"""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?

You don't need to do anything special, any NULL values will be indexed automatically.

- Heikki

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to