On Wed, 2009-09-02 at 09:39 -0600, Kevin Kempter wrote:
> >
> > You sure you remembered those fiddly little casts everywhere?
> > (Frankly, declaring "time" as integer and not timestamp here strikes
> > me as utter lunacy.) What PG version are you using?
> >
> > regards, tom lane
>
As far as I know constraint exclusion doesn't work with date_part or
extract().
The following caveats apply to constraint exclusion:
* Constraint exclusion only works when the query's WHERE clause
contains constants. A parameterized query will not be optimized,
since the planner cannot know which partitions the parameter
value might select at run time. For the same reason, "stable"
functions such as CURRENT_DATE must be avoided.
http://www.postgresql.org/docs/8.3/static/ddl-partitioning.html
Or did I miss something?
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering