Re: Forcing filter/join order?

Peter,

>     I'm sure the big brains have a better suggestion, but in the mean time
> could you do something as simple as:
>
> SELECT *
> FROM (select * from events where event_date BETWEEN 'date1' AND 'date2') e
> LEFT OUTER JOIN cases ON e.case_id = cases.case_id;

Thanks, but that doens't work; the planner will collapse the subquery into the
main query, which most of the time is the right thing to do.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco