Re: FW: Help with order by into a RECORD

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Shaun Clements <ShaunC(at)relyant(dot)co(dot)za>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: FW: Help with order by into a RECORD
Date: 2005-04-01 14:00:34
Message-ID: 20050401140034.GC26112@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Apr 01, 2005 at 11:42:35 +0200,
Shaun Clements <ShaunC(at)relyant(dot)co(dot)za> wrote:
>
> I have a questions regarding my order by problem.
> If you index a table, can you query the table using ORDER BY. ?

Whether or not a table is indexed doesn't affect whether or not you can
use ORDER BY. It may affect the performance depending on what you are
doing.

If you are having some specific problem it is probably best to provide
details about it, rather than guess at what might be the problem and
ask here whther or not the guess could be right.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-04-01 15:03:50 Re: PL/PERL with composite return values & PGSQL 7.4?
Previous Message Bruno Wolff III 2005-04-01 13:57:00 Re: Debugging deadlocks