Re: The planner hates me.

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us] 


The Right Way (tm) to do this would be something like

	create temp table dates as select * from get_dates(...);
	analyze dates;
	... original select, but join against temp table ...

which would leave the planner armed with some stats about the range
of dates of interest.  

------------

I actually tried that   but minus the analyze..... :(

Btw, congrats on whomever contributed to the bitmap scans (v8.1 I
believe)....the ability to use multiple indexes for a single table in
the same query is fantastic!!