Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id 3638C476AA1
	for <pgsql-sql@postgresql.org>; Wed, 19 Jun 2002 04:21:26 -0400 (EDT)
Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52])
	by postgresql.org (Postfix) with SMTP id 8BAA8476762
	for <pgsql-sql@postgresql.org>; Wed, 19 Jun 2002 04:18:39 -0400 (EDT)
Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ;
 Wed Jun 19 10:18:39 2002 +0200
Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id KAA11417; Wed, 19 Jun 2002 10:18:38 +0200 (METDST)
From: Christoph Haller <ch@rodos.fzk.de>
Message-Id: <200206190818.KAA10200@rodos>
Subject: Re: Aggregates not allowed in WHERE clause?
To: jtr@uni-bonn.de (Joachim Trinkwitz)
Date: Wed, 19 Jun 2002 10:18:38 METDST
Cc: pgsql-sql@postgresql.org
In-Reply-To: <874rfzr8xj.fsf@waffel.germanistik.uni-bonn.de>;
	from "Joachim Trinkwitz" at Jun 19, 102 10:06 am
X-Mailer: Elm [revision: 212.4]
X-Archive-Number: 200206/243
X-Sequence-Number: 8208

Joachim, 
Try 

SELECT kvvnr, semester FROM lv 
WHERE semester = (SELECT MAX(semester) FROM lf_sem) ; 

Are you sure the MAX function will work on your 
text resp. char/varchar attribute 'semester'? 

Regards, Christoph