Does PostgreSQL have implicit Order-by - Mailing list pgsql-general

From nj7e@yahoo.com (John Moore)
Subject Does PostgreSQL have implicit Order-by
Date
Msg-id f91dbbdd.0106060801.5569ba7@posting.google.com
Whole thread Raw
List pgsql-general
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

pgsql-general by date:

Previous
From: Mario Weilguni
Date:
Subject: Re: foreign keys constraints, depending on each other
Next
From: Martín Marqués
Date:
Subject: Re: tables, permissions, sequences