"Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
> Assume the following:
> index on: (id, adate)
> constraint CHECK(adate > '01-01-2007' AND adate < '04-01-2007');

> The planner will not use the index listed above.

For what?

			regards, tom lane

In response to

• Constraint exclusion oddity with composite index at 2007-06-01 20:07:31 from Joshua D. Drake

Responses

• Re: Constraint exclusion oddity with composite index at 2007-06-01 21:03:07 from Joshua D. Drake

pgsql-hackers by date

Next:	From: Joshua D. Drake	Date: 2007-06-01 21:03:07
	Subject: Re: Constraint exclusion oddity with composite index
Previous:	From: Tom Lane	Date: 2007-06-01 20:46:10
	Subject: Re: Command tags in create/drop scripts