Re: [GENERAL] Select MIN() & MAX()
От | Dimitri |
---|---|
Тема | Re: [GENERAL] Select MIN() & MAX() |
Дата | |
Msg-id | 9808121955500C.00535@dimitri обсуждение исходный текст |
Ответ на | Select MIN() & MAX() ("Krasnow, Greg" <gak@hnc.com>) |
Список | pgsql-general |
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 =====================================================
В списке pgsql-general по дате отправления: