Re: Another optimizer question

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Dennis Haney <davh(at)diku(dot)dk>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Another optimizer question
Date: 2004-01-27 17:41:35
Message-ID: 20040127174135.GA14806@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jan 27, 2004 at 17:27:25 +0100,
Dennis Haney <davh(at)diku(dot)dk> wrote:
>
> Is it just me, or is there any way a sort could be relevant in a
> subquery? (except on queries containing volatile functions)

Yes. It is important when a limit or distinct on clause is used in a
subquery.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Cramer 2004-01-27 17:41:41 Re: index scan with functional indexes
Previous Message Tom Lane 2004-01-27 17:33:01 Re: index scan with functional indexes