> Yes, NULL values are not stored in the index, but you may create functional
> index on
>
Are you sure NULL values are not stored? btree, gist and bitmap index and
search for NULL values.
select amname, amindexnulls, amsearchnulls from pg_am;
amname | amindexnulls | amsearchnulls
--------+--------------+---------------
btree | t | t
hash | f | f
gist | t | t
gin | f | f
bitmap | t | t
(5 rows)
Sincerely yours,
Vladimir Sitnikov