On Wed, 5 Oct 2011, David Johnston wrote:
"Max" is an aggregate function and thus requires one of: 1) GROUP BY 2) "Window" - max(quant) OVER (PARTITION BY ...) To be present in the query.
David, I was unaware of the windows functions. I see the document page for 9.0.5 so I'll carefully read that and upgrade from 9.0.4 (which may also have this function; I'll check). Thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
