Teach simplify_boolean_equality to simplify the forms foo <> true and
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 20 Jul 2009 00:24:30 +0000 (00:24 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 20 Jul 2009 00:24:30 +0000 (00:24 +0000)
commit31d1f2330277a91f59fe050cc85ced25ee55f95d
tree3f88cf38bfedccb16cfa18c116981aae45e8bbf3
parent400e2c934457bef4bc3cc9a3e49b6289bd761bc0
Teach simplify_boolean_equality to simplify the forms foo <> true and
foo <> false, along with its previous duties of simplifying foo = true
and foo = false.  (All of these are equivalent to just foo or NOT foo
as the case may be.)  It's not clear how often this is really useful;
but it costs almost nothing to do, and it seems some people think we
should be smart about such cases.  Per recent bug report.
src/backend/optimizer/util/clauses.c
src/include/catalog/pg_operator.h