Re: Aggregates not allowed in WHERE clause?

From: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
To: jtr(at)uni-bonn(dot)de (Joachim Trinkwitz)
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Aggregates not allowed in WHERE clause?
Date: 2002-06-19 10:18:38
Message-ID: 200206190818.KAA10200@rodos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Janning Vygen 2002-06-19 10:33:47 Joining three data sources.
Previous Message Oleg Bartunov 2002-06-19 08:41:37 Re: Help with a "recursive" query