Reid Thompson <reid(dot)thompson(at)ateb(dot)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