"Joshua D. Drake" <j...@commandprompt.com> writes: > On Mon, 2008-12-15 at 14:28 -0500, Tom Lane wrote: >> "Joshua D. Drake" <j...@commandprompt.com> writes: >>> Of the functions the only one that will use constraint_exclusion is the >>> one that explicitly passes the date value. >> >> Since you haven't shown us the constraints you're talking about, or the >> resulting plans, it's difficult for anyone to guess what's going on.
> Check constraints: > "foo_stats_day_q1_day_check" CHECK (day >= '2007-01-01'::date AND > day < '2007-04-01'::date) Well, that certainly looks like constraint exclusion should work with the EXECUTE case. What leads you to conclude it doesn't? regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers