Re: pgsql/src/include/optimizer (paths.h planmain.h) - Mailing list pgsql-committers

From Bruce Momjian
Subject Re: pgsql/src/include/optimizer (paths.h planmain.h)
Date
Msg-id 200007271853.OAA26975@candle.pha.pa.us
Whole thread Raw
In response to pgsql/src/include/optimizer (paths.h planmain.h)  (Tom Lane <tgl>)
List pgsql-committers
>   Date: Sunday, July 23, 2000 @ 23:10:54
> Author: tgl
>
> Update of /home/projects/pgsql/cvsroot/pgsql/src/include/optimizer
>      from hub.org:/home/projects/pgsql/tmp/cvs-serv74468/include/optimizer
>
> Modified Files:
>     paths.h planmain.h
>
> -----------------------------  Log Message  -----------------------------
>
> Deduce equality constraints that are implied by transitivity of
> mergejoinable qual clauses, and add them to the query quals.  For
> example, WHERE a = b AND b = c will cause us to add AND a = c.
> This is necessary to ensure that it's safe to use these variables
> as interchangeable sort keys, which is something 7.0 knows how to do.
> Should provide a useful improvement in planning ability, too.
>

Hard to imagine this didn't happen before.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-committers by date:

Previous
From: Bruce Momjian - CVS
Date:
Subject: pgsql/doc (TODO)
Next
From: Bruce Momjian - CVS
Date:
Subject: pgsql/doc/TODO.detail (cidr)