pgsql/src/backend/optimizer/plan (initsplan.c planmain.c)

From: Tom Lane <tgl>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql/src/backend/optimizer/plan (initsplan.c planmain.c)
Date: 2000-07-24 03:11:06
Message-ID: 200007240311.e6O3B6974568@hub.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Date: Sunday, July 23, 2000 @ 23:11:04
Author: tgl

Update of /home/projects/pgsql/cvsroot/pgsql/src/backend/optimizer/plan
from hub.org:/home/projects/pgsql/tmp/cvs-serv74468/backend/optimizer/plan

Modified Files:
initsplan.c planmain.c

----------------------------- 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.

Browse pgsql-committers by date

  From Date Subject
Next Message Philip Warner - CVS 2000-07-24 06:24:26 pgsql/src/bin/pg_dump (Makefile pg_backup_archiver.c pg_backup_archiver.h pg_backup_db.c pg_backup_plain_text.c pg_dump.c)
Previous Message Tom Lane 2000-07-24 03:11:00 pgsql/src/backend/optimizer/path (pathkeys.c)