Frequently one wants a data set returned in the same order as the index used in the query. Informix (at least) has implicit order-by, which means that the data will be returned in collating order if the query forces use of the appropriate index. Does Postgresql do this? If not, does an Order-by force a sort even if an index has the correct order to satisfy the order-by? Thanks John Moore [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html