pgsql: Tweak trivial_subqueryscan() to consider a SubqueryScan's

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Tweak trivial_subqueryscan() to consider a SubqueryScan's
Date: 2006-08-28 14:32:42
Message-ID: 20060828143242.5A5589FCF6F@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Tweak trivial_subqueryscan() to consider a SubqueryScan's targetlist
trivial if it contains either Vars referencing the corresponding subplan
columns, or Consts equaling the corresponding subplan columns. This
lets the planner eliminate the SubqueryScan in some cases generated by
generate_setop_tlist().

Modified Files:
--------------
pgsql/src/backend/optimizer/plan:
setrefs.c (r1.124 -> r1.125)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/setrefs.c.diff?r1=1.124&r2=1.125)

Browse pgsql-committers by date

  From Date Subject
Next Message User Okbob 2006-08-28 15:09:45 orafce - orafce: updated for 8.2 ..
Previous Message User Okbob 2006-08-28 14:11:30 orafce - orafce: table is protected via rules