diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2009-07-20 00:24:30 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2009-07-20 00:24:30 +0000 |
commit | 31d1f2330277a91f59fe050cc85ced25ee55f95d (patch) | |
tree | 3f88cf38bfedccb16cfa18c116981aae45e8bbf3 /src/include | |
parent | 400e2c934457bef4bc3cc9a3e49b6289bd761bc0 (diff) | |
download | postgresql-31d1f2330277a91f59fe050cc85ced25ee55f95d.tar.gz postgresql-31d1f2330277a91f59fe050cc85ced25ee55f95d.zip |
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.
Diffstat (limited to 'src/include')
-rw-r--r-- | src/include/catalog/pg_operator.h | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/include/catalog/pg_operator.h b/src/include/catalog/pg_operator.h index 8cea420cd69..e4aef392dea 100644 --- a/src/include/catalog/pg_operator.h +++ b/src/include/catalog/pg_operator.h @@ -8,7 +8,7 @@ * Portions Copyright (c) 1996-2009, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $PostgreSQL: pgsql/src/include/catalog/pg_operator.h,v 1.166 2009/06/11 14:49:09 momjian Exp $ + * $PostgreSQL: pgsql/src/include/catalog/pg_operator.h,v 1.167 2009/07/20 00:24:30 tgl Exp $ * * NOTES * the genbki.sh script reads this file and generates .bki @@ -93,6 +93,7 @@ DATA(insert OID = 82 ( ">=" PGNSP PGUID b f f 23 20 16 420 37 int48ge scalar DATA(insert OID = 58 ( "<" PGNSP PGUID b f f 16 16 16 59 1695 boollt scalarltsel scalarltjoinsel )); DATA(insert OID = 59 ( ">" PGNSP PGUID b f f 16 16 16 58 1694 boolgt scalargtsel scalargtjoinsel )); DATA(insert OID = 85 ( "<>" PGNSP PGUID b f f 16 16 16 85 91 boolne neqsel neqjoinsel )); +#define BooleanNotEqualOperator 85 DATA(insert OID = 91 ( "=" PGNSP PGUID b t t 16 16 16 91 85 booleq eqsel eqjoinsel )); #define BooleanEqualOperator 91 DATA(insert OID = 1694 ( "<=" PGNSP PGUID b f f 16 16 16 1695 59 boolle scalarltsel scalarltjoinsel )); |