git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Add IS UNKNOWN, IS NOT UNKNOWN boolean tests, fix the existing boolean

author Tom Lane <tgl@sss.pgh.pa.us>

2001年6月19日 22:39:12 +0000 (22:39 +0000)

committer Tom Lane <tgl@sss.pgh.pa.us>

2001年6月19日 22:39:12 +0000 (22:39 +0000)

commit 116d2bba7eeaf25c544bc187e3ad2a8677a9a22c

tree c77a6b20a3acdbb6e25a1fc4a561c0e839ddbb1e tree

parent 8c30aca2ba1a48d38b1206f8559d1dc6b65c5ca7 commit | diff

Add IS UNKNOWN, IS NOT UNKNOWN boolean tests, fix the existing boolean
tests to return the correct results per SQL9x when given NULL inputs.
Reimplement these tests as well as IS [NOT] NULL to have their own
expression node types, instead of depending on special functions.
From Joe Conway, with a little help from Tom Lane.

18 files changed:

doc/src/sgml/func.sgml diff | blob | blame | history

doc/src/sgml/syntax.sgml diff | blob | blame | history

src/backend/executor/execQual.c diff | blob | blame | history

src/backend/nodes/copyfuncs.c diff | blob | blame | history

src/backend/nodes/equalfuncs.c diff | blob | blame | history

src/backend/nodes/outfuncs.c diff | blob | blame | history

src/backend/nodes/readfuncs.c diff | blob | blame | history

src/backend/optimizer/util/clauses.c diff | blob | blame | history

src/backend/parser/gram.y diff | blob | blame | history

src/backend/parser/keywords.c diff | blob | blame | history

src/backend/parser/parse_clause.c diff | blob | blame | history