Does PostgreSQL have implicit Order-by

From: nj7e(at)yahoo(dot)com (John Moore)
To: pgsql-general(at)postgresql(dot)org
Subject: Does PostgreSQL have implicit Order-by
Date: 2001-06-06 16:01:47
Message-ID: f91dbbdd.0106060801.5569ba7@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Martín Marqués 2001-06-06 16:12:46 Re: [HACKERS] something smells bad
Previous Message Martín Marqués 2001-06-06 15:57:13 Re: [HACKERS] something smells bad