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: alpine.DEB.2.00.0903301125020.21772@aragorn.flymine.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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?
> http://www.postgresql.org/docs/8.3/interactive/sql-createaggregate.html

Can you return multiple rows from an aggregate function?

Matthew

--

In response to

Browse pgsql-performance by date

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