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: alpine.DEB.2.00.0903301125020.21772@aragorn.flymine.org (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group