On Mon, 2007-03-26 at 09:38 -0700, Weslee Bilodeau wrote:
> mytest=# explain select count(*) from master where var_ts > (
> '2007-03-26 16:03:27.370627+00'::timestamptz - '1 month'::interval
> )::timestamptz ;
If you're able to supply a constant value, why not subtract 1 month
before you submit the query?
AFAIK timestamptz arithmetic depends upon the current timezone which is
a STABLE value and so won't currently work with partitioning.
Having partitioning work with STABLE functions should be a TODO item if
it isn't already, but that requires some thought to implement and won't
happen for 8.3.
-- Simon Riggs EnterpriseDB http://www.enterprisedb.com