> >> Assume the following:
> >> index on: (id, adate)
> >> constraint CHECK(adate > '01-01-2007' AND adate < '04-01-2007');
Um, the subject is CE, but the question is about an index ? Those are
> >> The planner will not use the index listed above.
> > For what?
> select adate from parent where adate = '01-25-2007'
A possibly cheaper plan would be a self join to produce all possible
id's and join the index for each (id, adate) pair.
Note, that you need not check visibility of the id's you produce (index
Is that what you were expecting ? This is not implemented.
In response to
pgsql-hackers by date
|Next:||From: Teodor Sigaev||Date: 2007-06-04 12:06:15|
|Subject: Re: Tsearch vs Snowball, or what's a source file?|
|Previous:||From: Zdenek Kotala||Date: 2007-06-04 10:14:27|
|Subject: Re: Command tags in create/drop scripts|