I was thinking if this was possible in some way.. I have this table where we have X and Y coordinates, and i need to select several in one go. # select * from xy where (x = 1 and y = 2) or (x = 2 and y = 2); This works but are not so nice looking. It would be nice to be able to do it like this: # select * from xy where (x, y) in ((1, 2), (2, 2)); But that doesn't work. A funny thing is that this works: # select * from xy where (x, y) = (1, 2); What's the most efficient way of doing these kind of selects? A multicol index on x and y is what we currently do and the first select above... Regards, Magnus ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
