Hi.
I hope, that this is right mailing list.
SELECT date, value FROM t_eventWHERE t_event.id in (SELECT id FROM t_event WHERE date < '2009-08-25' ORDER BY
dateDESC LIMIT 1)ORDER BY date;
cost 6.4
SELECT date, value FROM t_eventWHERE t_event.id = (SELECT id FROM t_event WHERE date < '2009-08-25' ORDER BY date
DESCLIMIT 1)ORDER BY date;
cost 6.36..6.37
Why that two query dont have equal cost? If it is not problem, try add some
planer code to recognize that sublesect HAVE TO return just one row (limit 1)
and in plan could be used filter/index scan instead of hash aggregate. I have
also some complex query examples where cost difference is more visible.
Have a nice day.
--
Odborník na všetko je zlý odborník. Ja sa snažím byť výnimkou potvrdzujúcou
pravidlo.