Home > mailing lists

select max from subquery - Mailing list pgsql-general

From	searchelite
Subject	select max from subquery
Date	February 14, 2009 10:05:35
Msg-id	22011562.post@talk.nabble.com Whole thread Raw
Responses	Re: select max from subquery Re: select max from subquery Re: select max from subquery
List	pgsql-general

Tree view

Dear All

i gave this kind of query

select max(foo) from (select some statement) as foo

but it gave me this error
ERROR:  function max(record) does not exist


any help how i can select max value from suqbuery in main query

thanks
--
View this message in context: http://www.nabble.com/select-max-from-subquery-tp22011562p22011562.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

From: benoît carpentier
Date: 14 February 2009, 09:35:12
Subject: Benetl, a free ETL tool for files using postgreSQL, is out in version 2.5 !

From: Raymond O'Donnell
Date: 14 February 2009, 10:09:23
Subject: Re: select max from subquery

select max from subquery - Mailing list pgsql-general

Previous

Next