Postgres Pro
Downloads
Home   >   mailing lists

Re: How to find out top 3 records in each location - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: How to find out top 3 records in each location
Date
Msg-id 20061120174822.GB29317@phlogiston.dyndns.org
Whole thread Raw
In response to How to find out top 3 records in each location  ("wen tseng" <went@hteamericas.com>)
List pgsql-sql
Tree view 
On Mon, Nov 20, 2006 at 12:09:00PM -0500, wen tseng wrote:
> 
> Since PostgreSQL doesn't support TOP, how can I do to get this result?
> Any solution will be appreciated.

Check out the crosstab stuff in contrib/; I think it does what you
want.

a

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
The whole tendency of modern prose is away from concreteness.    --George Orwell

pgsql-sql by date:

Previous
From: "wen tseng"
Date:
Subject: How to find out top 3 records in each location
Next
From: Richard Broersma Jr
Date:
Subject: Re: How to find out top 3 records in each location