Postgres Pro
Downloads
Home   >   mailing lists

Re: Aggregates not allowed in WHERE clause? - Mailing list pgsql-sql

From Christoph Haller
Subject Re: Aggregates not allowed in WHERE clause?
Date
Msg-id 200206190818.KAA10200@rodos
Whole thread Raw
In response to Aggregates not allowed in WHERE clause?  (Joachim Trinkwitz <jtr@uni-bonn.de>)
Responses Re: Aggregates not allowed in WHERE clause?
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: Aggregates not allowed in WHERE clause?
Next
From: Oleg Bartunov
Date:
Subject: Re: Help with a "recursive" query