On Thu, Oct 28, 2010 at 1:49 PM, AI Rumman <rummandba@xxxxxxxxx> wrote: > But I am using Postgresql 8.1 and it is not possible to write query as your > one here. with 8.1, you are limited to subquery approach, application derived count, plpgsql hacks, etc. merlin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance