Implicit order-by in Postgresql?

From: "earthlink" <NOSPAMnews(at)tinyvital(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Implicit order-by in Postgresql?
Date: 2001-06-08 16:49:13
Message-ID: dm7U6.2733$p%4.249875@newsread2.prod.itd.earthlink.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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
newsNOSPAM(at)tinyvital(dot)com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2001-06-08 16:53:16 Re: [HACKERS] Re: behavior of ' = NULL' vs. MySQL vs. Standards
Previous Message earthlink 2001-06-08 16:48:01 Internal pointers clobbered on system crash without fsync???