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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

dip=> create table t ( x int , y int );
CREATE
dip=> select x,min(y) from t group by x;
x|min
-+---
|
(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.

Alain

Responses

Browse pgsql-bugs by date

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