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 have 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster