On 22/01/2010 15:31, Volkan Varol wrote:
[snip]
> my scenario this is unavoidable since I require it, but there may be a
> trick to reduce its overall cost.
>
> The only alternative solution I've come up with so far is to save row
> counts into the table itself using triggers. Is this reasonable or not?
That approach has been suggested in the past, and seems a viable one.
> I'm in search for a new method / syntax to combine these two queries and
> I welcome your suggestions.
Would common table expressions be any use to you? -
http://www.postgresql.org/docs/8.4/static/queries-with.html
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie