Re: Select first ten of each category? - Mailing list pgsql-general

From Yanni Chiu
Subject Re: Select first ten of each category?
Date
Msg-id e1knn3$h9j$1@sea.gmane.org
Whole thread Raw
In response to Re: Select first ten of each category?  (Michael Glaesemann <grzm@myrealbox.com>)
List pgsql-general
Michael Glaesemann wrote:
> Without using UNION, (which would require writing a select statement
> for each category), how would LIMIT allow him to do this for each
> category in a single query?

You're right, it would need a UNION, and a SELECT per category.
So there'd be another SELECT to find all the categories beforehand.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Truncate and Foreign Key Constraint question
Next
From: "Gregory S. Williamson"
Date:
Subject: Re: Truncate and Foreign Key Constraint question