Benjamin Smith wrote:
It has a LARGE number of entries. I'd like to grab the 10 most expensive items from each category in a single query. How can this be done?
Use a LIMIT on your SELECT. See: http://www.postgresql.org/docs/8.1/static/queries-limit.html
