Re: Group by and limit

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