On Wed, 12 Aug 1998, you wrote:
>In the documentation it mentions that Postgresql does not currently support
>MIN() and MAX() in the select list, but only in the where clause... will
>this be available in the next version of Postgresql and is there another way
>to do this in the current version?
I don't know what is written in the doc, but in practice
select MAX( Attr ) from Table;
select MIN( Attr ) from Table;
select AVG( Attr ) from Table;
etc.
works without problem for me (v.6.3.2)
>
>- Greg
>
>
>Greg Krasnow
>HNC Software Inc.
>Financial Solutions Group
>Senior Software Engineer
>Email: gak@hnc.com
>Direct Phone: 619.799.8341
>Fax: 619.799.8036
--
=====================================================
Dimitri KRAVTCHUK (dim) Sun Microsystems
Benchmark Engineer France
dimitri@France.Sun.COM
=====================================================