strk <[EMAIL PROTECTED]> writes: > Testing postgis support in PG7.4 (2003-11-11) > I've encountered to this problem: > ERROR: could not identify an ordering operator for type geometry > Previous PG versions does not show this problem. > Any hint on what might be missing ?
A default btree operator class for type geometry. PG 7.4 no longer uses assumptions about operator names to determine sorting/grouping behavior. If you have some operators that provide a scalar sort ordering on your datatype, then make a btree opclass to show that. See http://www.postgresql.org/docs/7.4/static/xindex.html#XINDEX-OPCLASS-DEPENDENCIES regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html