"Joshua D. Drake" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
