"order by" weirdness - Mailing list pgsql-sql

From Hein Roehrig
Subject "order by" weirdness
Date
Msg-id E11VP8G-0005nY-00@godot.normed.de
Whole thread Raw
List pgsql-sql
Hello,

consider these three statements:

create table t (id integer, date datetime ) ;
select id from t group by id ;
select id from t group by id order by max(date) ;

Is it correct behavior that the second select returns one row where
as the first select returns zero rows? 

Thanks in advance for any help,
Hein




pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] IFNULL - problem
Next
From: Dipankar Chakrabarti
Date:
Subject: Re: "order by" weirdness