The datatype of the join columns is a user defined type and there are no commutators defined. I will fix that and retest. Thanks for the insight.
Mike Quinn ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq