Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 1842A475D6C for ; Thu, 20 Jun 2002 04:06:21 -0400 (EDT) Received: from waffel.germanistik.uni-bonn.de (waffel.germanistik.uni-bonn.de [131.220.90.150]) by postgresql.org (Postfix) with ESMTP id 89BC0475D70 for ; Thu, 20 Jun 2002 04:06:19 -0400 (EDT) Received: by waffel.germanistik.uni-bonn.de (Postfix, from userid 1000) id 5C4BB13198E; Thu, 20 Jun 2002 10:05:31 +0200 (CEST) To: pgsql-sql@postgresql.org Subject: Re: Aggregates not allowed in WHERE clause? References: <200206190818.KAA10200@rodos> From: Joachim Trinkwitz Date: 20 Jun 2002 10:05:29 +0200 In-Reply-To: <200206190818.KAA10200@rodos> Message-ID: <87znxqpe7q.fsf@waffel.germanistik.uni-bonn.de> Lines: 12 User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.4 (Honest Recruiter) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200206/268 X-Sequence-Number: 8233 Thanks for all your answers, it is working now. Christoph Haller writes: > Are you sure the MAX function will work on your > text resp. char/varchar attribute 'semester'? Yes, this works, I think because the ASCII (or whatever) value of 's' is lower than that of 'w'. Greetings, joachim