On Oct 20, 2007, at 12:19 PM, Andreas Kretschmer wrote:
Markus Schaber <[EMAIL PROTECTED]> schrieb:
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 go
Thanks a lot folks,
Left the query running for 10+ hours and had to kill it. I guess there really
was no need to have lots of
shared buffers (the hope was that postgresql will cache the whole table). I
ended up doing this step inside
the application as a pre-processing step. Can't have postgres
Markus Schaber <[EMAIL PROTECTED]> schrieb:
> > 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
Hi, Stefano,
"Stefano Dal Pra" <[EMAIL PROTECTED]> wrote:
> 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,
> e