pgsql/src/backend/optimizer/plan planner.c

Started by Tom Laneabout 24 years ago3 messagescomitters
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

CVSROOT: /cvsroot
Module name: pgsql
Changes by: tgl@postgresql.org 02/06/13 11:10:25

Modified files:
src/backend/optimizer/plan: planner.c

Log message:
Make WHERE conditions pulled up from subqueries be executed before outer
WHERE conditions, if there is no reason to do it differently.

#2Christopher Kings-Lynne
chriskl@familyhealth.com.au
In reply to: Tom Lane (#1)
Re: pgsql/src/backend/optimizer/plan planner.c

Just out of interest - why is that better?

Chris

Show quoted text

-----Original Message-----
From: pgsql-committers-owner@postgresql.org
[mailto:pgsql-committers-owner@postgresql.org]On Behalf Of Tom Lane
Sent: Thursday, 13 June 2002 11:10 PM
To: pgsql-committers@postgresql.org
Subject: [COMMITTERS] pgsql/src/backend/optimizer/plan planner.c

CVSROOT: /cvsroot
Module name: pgsql
Changes by: tgl@postgresql.org 02/06/13 11:10:25

Modified files:
src/backend/optimizer/plan: planner.c

Log message:
Make WHERE conditions pulled up from subqueries be executed
before outer
WHERE conditions, if there is no reason to do it differently.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Christopher Kings-Lynne (#2)
Re: pgsql/src/backend/optimizer/plan planner.c

"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:

Just out of interest - why is that better?

See Mike Mascari's recent gripes about functions and views.
This is a pretty weak security improvement, but not a negligible
one.

regards, tom lane