Re: Re: is this possible? it should be! - Mailing list pgsql-general

From newsreader@mediaone.net
Subject Re: Re: is this possible? it should be!
Date
Msg-id 20010821085019.A31396@dragon.universe
Whole thread Raw
In response to Re: Re: is this possible? it should be!  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
On Mon, Aug 20, 2001 at 10:30:07PM -0700, Stephan Szabo wrote:
>
>
> I don;'t know if it's considered now, but that query (the
> original) doesn't necessarily require a sort step.  With an index on
> (d,e) I think you could do the query using the index for both the
> constraint (d=2) and the ordering stopping when you have 10 rows.

I see.  What I am asking is impossible then.

Thanks.  I will have to go with two queries
approach

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Dynamically discovering field names in PLPGSQL queries
Next
From: Stephan Szabo
Date:
Subject: Re: Sort by foreign date column