Postgres Pro
Downloads
Home   >   mailing lists

Re: Help with order by into a RECORD - Mailing list pgsql-general

From Richard Huxton
Subject Re: Help with order by into a RECORD
Date
Msg-id 424D1FCE.4030603@archonet.com
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "GIROIRE Nicolas (COFRAMI)"
Date:
Subject: Re: Help with order by into a RECORD
Next
From: Shaun Clements
Date:
Subject: Re: : Postgres order by into a RECORD, not ordering