pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: tgl@postgresql.org
To: pgsql-committers@postgresql.org
Subject: pgsql: Teach simplify_boolean_equality to simplify the forms foo <> true
Date: Mon, 20 Jul 2009 00:24:31 +0000 (UTC)
Message-ID: <20090720002431.2060E75331E@cvs.postgresql.org> (raw)

Log Message:
-----------
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.

Modified Files:
--------------
    pgsql/src/backend/optimizer/util:
        clauses.c (r1.277 -> r1.278)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/clauses.c?r1=1.277&r2=...)
    pgsql/src/include/catalog:
        pg_operator.h (r1.166 -> r1.167)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_operator.h?r1=1.166&r2=1.1...)




view thread (2+ messages)  latest in thread

Message-ID: <20090720002431.2060E75331E@cvs.postgresql.org>
Permalink:  ../20090720002431.2060E75331E@cvs.postgresql.org/
Also on:    postgresql.org/message-id/20090720002431.2060E75331E@cvs.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: tgl@postgresql.org
  Subject: Re: pgsql: Teach simplify_boolean_equality to simplify the forms foo <> true
  In-Reply-To: <20090720002431.2060E75331E@cvs.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox