Postgres Pro
Downloads
Home   >   mailing lists

Re: Group by and limit - Mailing list pgsql-general

From Dimitri Fontaine
Subject Re: Group by and limit
Date
Msg-id m2lj5aye27.fsf@2ndQuadrant.fr
Whole thread Raw
In response to Group by and limit  (Reid Thompson <reid.thompson@ateb.com>)
List pgsql-general
Tree view 
Reid Thompson <reid.thompson@ateb.com> writes:
> I only want the first 500 for each x.
> Any tips or tricks someone might know would be appreciated.
> I’m using postgres 8.3.7.

  http://troels.arvin.dk/db/rdbms/#select-top-n

Consider using a more recent version of PostgreSQL, equipped with window
functions!

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: timestamps in Australia
Next
From: Jasen Betts
Date:
Subject: Re: Why Select Count(*) from table - took over 20 minutes?