]> granicus.if.org Git - postgresql/commit
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)
commitf02a82b6adad1af75499c4ac7221bbd94e3c4fbf
treed15b0a2a52d95e046bb3945f4487982943ed211e
parent146c83c045625d6f0072dd96045ebbc54582be05
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