Received: from hera.cwi.nl (hera.cwi.nl [192.16.191.1])
	by hub.org (8.9.3/8.9.3) with ESMTP id VAA05487
	for <pgsql-sql@postgresql.org>; Sun, 26 Sep 1999 21:07:14 -0400 (EDT)
	(envelope-from roehrig@cwi.nl)
Received: from godot.normed.de (kaneel.cwi.nl [192.16.201.218]) by hera.cwi.nl
	with ESMTP id DAA14168 for <pgsql-sql@postgresql.org>;
	Mon, 27 Sep 1999 03:06:32 +0200 (MET DST)
Received: from localhost ([127.0.0.1] helo=godot.normed.de)
	by godot.normed.de with esmtp (Exim 3.03 #1 (Debian))
	id 11VP8G-0005nY-00
	for <pgsql-sql@postgresql.org>; Sun, 26 Sep 1999 20:59:08 -0400
X-Mailer: exmh version 2.0.2 2/24/98 (debian) 
From: Hein Roehrig <hein@acm.org>
X-url: http://www.cwi.nl/~roehrig
To: pgsql-sql@postgresql.org
Subject: "order by" weirdness
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Date: Sun, 26 Sep 1999 20:59:07 -0400
Sender: roehrig@godot.normed.de
Message-Id: <E11VP8G-0005nY-00@godot.normed.de>
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id VAA05497

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