"Shaun Thomas" <sthomas@xxxxxxxxxxxxxxxxxx> writes: > Simply changing: > now() - interval '2 days' > to > '2006-06-11 15:30:00' > generated a much more accurate set of estimates. Yeah, 7.4 won't risk basing estimates on the results of non-immutable functions. We relaxed that in 8.0 I believe. regards, tom lane
