> Surely the planner is aware that '2003-01-01'::date - interval '1 week' is
a
> constant???
Actually, turns out that the planner was smarter than me I think. 2003-01-01
occurs very rarely in the system, but other dates occupy 1/7th of the table,
so it's not so easy to plan...
Chris