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