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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster