Make 'col IS NULL' clauses be indexable conditions.
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 6 Apr 2007 22:33:43 +0000 (22:33 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 6 Apr 2007 22:33:43 +0000 (22:33 +0000)
commitce8a17cee193918f38af965faf86e0db7c35ccbe
tree064b8d55f056c0b5c82eff9a328f86fb3b77defd
parentc28e0226f1c383800670320b10c80ae5287bb0ed
Make 'col IS NULL' clauses be indexable conditions.

Teodor Sigaev, with some kibitzing from Tom Lane.
19 files changed:
doc/src/sgml/catalogs.sgml
doc/src/sgml/indexam.sgml
doc/src/sgml/indices.sgml
doc/src/sgml/ref/create_index.sgml
src/backend/access/common/scankey.c
src/backend/access/gist/gistget.c
src/backend/access/nbtree/nbtsearch.c
src/backend/access/nbtree/nbtutils.c
src/backend/executor/nodeIndexscan.c
src/backend/optimizer/path/indxpath.c
src/backend/optimizer/plan/createplan.c
src/backend/optimizer/util/plancat.c
src/backend/utils/adt/selfuncs.c
src/include/access/skey.h
src/include/catalog/catversion.h
src/include/catalog/pg_am.h
src/include/nodes/relation.h
src/test/regress/expected/create_index.out
src/test/regress/sql/create_index.sql