Re: [GENERAL] Select MIN() & MAX()

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(at)hnc(dot)com
>Direct Phone: 619.799.8341
>Fax: 619.799.8036
--
=====================================================
Dimitri KRAVTCHUK (dim) Sun Microsystems
Benchmark Engineer France
dimitri(at)France(dot)Sun(dot)COM
=====================================================