"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