Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] Always one row with group by / agregate - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] Always one row with group by / agregate
Date
Msg-id 26173.946309963@sss.pgh.pa.us
Whole thread Raw
In response to Always one row with group by / agregate  ("Alain TESIO" <tesio@easynet.fr>)
List pgsql-bugs
Tree view 
"Alain TESIO" <tesio@easynet.fr> writes:
> dip=> select x,min(y) from t group by x;
> x|min
> -+---
>  |
> (1 row)

Yup, that's a bug --- with GROUP BY, no rows in should yield no groups
and hence no rows out.  It's fixed for the next release.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Alain TESIO"
Date:
Subject: Equal test on strings doesn't ignore trailing spaces if the function 'lower' is applied
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] Equal test on strings doesn't ignore trailing spaces if the function 'lower' is applied