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 flat)
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

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
Subject:

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