Skip site navigation (1) Skip section navigation (2)

Re: Very specialised query

From: Matthew Wakeling <matthew(at)flymine(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Very specialised query
Date: 2009-03-30 10:26:03
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On Fri, 27 Mar 2009, Dimitri Fontaine wrote:
> Maybe it's just that I didn't devote enough time to reading your detailed 
> explanation above, but this part sounds like it could be done in an aggregate 
> you'd use in a correlated subquery containing the right ORDER BY, couldn't 
> it?

Can you return multiple rows from an aggregate function?



In response to

pgsql-performance by date

Next:From: Alexander StauboDate: 2009-03-30 11:24:55
Subject: Re: Bad plan for nested loop + limit
Previous:From: Matthew WakelingDate: 2009-03-30 10:24:32
Subject: Re: Very specialised query

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group