Re: Help with order by into a RECORD
Yes, you can use ORDER BY on the table whiwh have an or several index.
Index allows to save time during execution of request.
-----Message d'origine-----
De : pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]De la part de Shaun Clements
Envoyé : vendredi 1 avril 2005 11:43
À : PostgreSQL General
Objet : FW: [GENERAL] Help with order by into a RECORD
Hi
I have a questions regarding my order by problem.
If you index a table, can you query the table using ORDER BY. ?
Kind Regards,
Shaun Clements
Shaun Clements wrote:
Hi Richard
I have a questions regarding my order by problem.
If you index a table, can you query the table using ORDER BY. ?
You can ORDER BY any combination of columns/expressions, whether they
are indexed or not. An index may make things quicker (it isn't
guaranteed to do so).
--
Richard Huxton
Archonet Ltd
Import Notes
Reply to msg id not found: 100F78F2B203444BB161BBA7077FF6131CD9D5@srldbexc003.relyant.co.zaReference msg id not found: 100F78F2B203444BB161BBA7077FF6131CD9D5@srldbexc003.relyant.co.za | Resolved by subject fallback