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

From Joachim Trinkwitz
Subject Re: Aggregates not allowed in WHERE clause?
Date
Msg-id 87znxqpe7q.fsf@waffel.germanistik.uni-bonn.de
Whole thread Raw
In response to Re: Aggregates not allowed in WHERE clause?  (Christoph Haller <ch@rodos.fzk.de>)
List pgsql-sql
Thanks for all your answers, it is working now.

Christoph Haller <ch@rodos.fzk.de> 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


pgsql-sql by date:

Previous
From: "Gaetano Mendola"
Date:
Subject: Re: Rows affected
Next
From: Christoph Haller
Date:
Subject: psql -E Floating exception (coredump)