Skip site navigation (1) Skip section navigation (2)

Always one row with group by / agregate

From: "Alain TESIO" <tesio(at)easynet(dot)fr>
To: "PGSQL Bugs" <pgsql-bugs(at)postgresql(dot)org>
Subject: Always one row with group by / agregate
Date: 1999-12-27 06:12:45
Message-ID: 00c801bf5032$82496c20$df5f72c3@atesio (view raw or whole thread)
Lists: pgsql-bugs
dip=> create table t ( x int , y int );
dip=> select x,min(y) from t group by x;
(1 row)

select min(y) should return one row with a null value, but it's
expected. I thought that the first part of the job was to process
the group by and then the select on each group, but it doesn't
seem to be the case.



pgsql-bugs by date

Next:From: Alain TESIODate: 1999-12-27 06:18:12
Subject: Equal test on strings doesn't ignore trailing spaces if the function 'lower' is applied
Previous:From: aaDate: 1999-12-25 03:18:00

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group