David F. Skoll wrote:
No, I'm sure a btree will work. However, won't the index be inefficient (i.e., very flat) if there are many entries with the same value? Or is this not a problem?
If you're concerned, why not try a partial index? Joe ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org