I need an aggregate with 2 parameters
От | Salvador Mainé |
---|---|
Тема | I need an aggregate with 2 parameters |
Дата | |
Msg-id | 3AA75167.68073235@yahoo.com обсуждение исходный текст |
Ответы |
Re: I need an aggregate with 2 parameters
Re: I need an aggregate with 2 parameters |
Список | pgsql-sql |
Hello: I have a table with pluviometrical data meteo (rain float, day date, oid station) I want to select the the day of maximum value for each year for a given measurement station. It should look like : select max(rain),day from meteo group by date_part('year', day) where station=7654765; though it obiously doesn't work. I think that an aggregate function would be the best way to do this, because the table is quite large and I need indexes for date and also for stations, so adding a new one for the rain is too much. But the aggregate should look like: max_rain(rain, day) and return the day corresponding to the maximum rain, So the query would be something like: select max(rain), max_rain(rain, day) from meteo group by date_part('year', day) where station=47654765; I've tried to define a composite type for rain and day and the neccesary functions to make the aggregate, but I cannot find the correct way. Can someone help me? Is this sollution possible? -- Salvador Maine http://www.ronincoders.com
В списке pgsql-sql по дате отправления: