DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:mime-version:content-type:content-transfer-encoding:content-disposition;
	b=Hvjn6ZB2U+oO1VdJTNJGUiF7UKgXxOIE8yeEiRBhN82YafoA5+mwS0rjFW4JxX5v8EFCvmke+0EM6mDwpY00N//XIRc12eTjW9OwAkH1pZ0aAL/Dm3o/q58MFgAg6Nb5Jzh9aHWAPsaAvj9qJ9MpqgdHQie/8xt6WmR0osOADuo=
Message-ID: <290a5abc0710170530v215cb2b0q4fa000ad43096a28@mail.gmail.com>
Date: Wed, 17 Oct 2007 14:30:52 +0200
From: "Stefano Dal Pra" <s.dalpra@gmail.com>
To: pgsql-sql@postgresql.org
Subject: two queryes in a single tablescan
Cc: pgsql-performance@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi everybody,

suppose you have a large table tab and two (or more) queryes like this:

SELECT count(*),A FROM tab WHERE C GROUP BY A;
SELECT count(*),B FROM tab WHERE C GROUP BY B;

is there any way to get both results in a single query,
eventually through stored procedure?
The retrieved [count(*),A] ; [count(*),B)] data couldnt fit
on a single table, of course.

The main goal would be to get multiple results while scanning the
table[s] once only
thus getting results in a faster  way.

This seems to me quite a common situation but i have no clue whether a neat
solution can be implemented through stored procedure.

Any hint?

Thank you

Stefano