Re: Help with order by into a RECORD

From: Richard Huxton <dev(at)archonet(dot)com>
To: Shaun Clements <ShaunC(at)relyant(dot)co(dot)za>, List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Help with order by into a RECORD
Date: 2005-04-01 10:17:50
Message-ID: 424D1FCE.4030603@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Shaun Clements 2005-04-01 10:22:21 Re: : Postgres order by into a RECORD, not ordering
Previous Message GIROIRE Nicolas (COFRAMI) 2005-04-01 09:56:23 Re: Help with order by into a RECORD