Hi, Is the use of lists "Where field IN ('A',...'Z')" faster than using multiple conditions like "Where field = 'A' OR .... field = 'Z'" ? In every situation ? Depends on what ?
Note: (I guess im mistaken, but i remeber seeing that at the pgsql manual somewhere) Thanks Marcus ---------------------------(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