Does PostgreSQL have implicit Order-by 
Author Message
 Does PostgreSQL have implicit Order-by
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



Mon, 24 Nov 2003 00:01:47 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Implicit order-by in Postgresql?

2. Implicit order-by in Postgresql?

3. POSTGRESQL - performance issue with implicit joins

4. Relying on implicit order of rows

5. Implicit ordering

6. having trouble with PostgreSQL 7.1.3

7. Postgresql and Ruby - any opensource software done

8. Postgresql and Ruby - any opensource software done with

9. Changing Column Order (Was Re: MySQL vs PostgreSQL.)

10. Having "HAVING" problems with GROUP BY.

11. Caché from InterSystems - doing wh at other MV vendors should be doing

12. ADO thinks DBMS is done, but DBMS ain't done


 
Powered by phpBB® Forum Software