Re: Bug? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Bug?
Date
Msg-id 12833.997491229@sss.pgh.pa.us
Whole thread Raw
In response to Bug?  (Martín Marqués <martin@bugs.unl.edu.ar>)
List pgsql-hackers
Martín Marqués <martin@bugs.unl.edu.ar> writes:
> What's wrong with this query that used to work great:

Impossible to tell, with that amount of information.

> As you can see count(*) is 1, even seeing 2 rows selected. What's wrong?

Since it's a GROUP BY query, that's not necessarily wrong.  The counts
are the number of input rows in each group.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: PL/pgSQL bug?
Next
From: Tatsuo Ishii
Date:
Subject: Re: PL/pgSQL bug?