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 r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
