VIEWs with aggregate functions
От | Paul Makepeace |
---|---|
Тема | VIEWs with aggregate functions |
Дата | |
Msg-id | 20041013223942.GB23202@mythix.realprogrammers.com обсуждение исходный текст |
Ответы |
Re: VIEWs with aggregate functions
Re: VIEWs with aggregate functions |
Список | pgsql-novice |
I'm probably missing something obvious here but I can't quite see it. Given, CREATE VIEW weekly_bar_info AS SELECT bar_name, MIN(bar_date) AS earliest_date, MAX(bar_date) AS latest_date, MIN(bar) as min_bar, MAX(bar) as max_bar FROM bar_data WHERE valid_weekly='t' GROUP BY bar_name What I'd like to be able do is WHERE bar_name = ? AND bar_date >= ? i.e. select over a date range but that isn't directly possible with the VIEW as is. Is there some way of achieving this? (The reason for the view is that that set of aggregate functions is appearing a few times in related queries, and that perl's Class::DBI is less of a headache with VIEWs.) Paul -- Paul Makepeace .............................. http://paulm.com/inchoate/ "If they asked us nicely, then we wouldnt be as happy with it." -- http://paulm.com/toys/surrealism/
В списке pgsql-novice по дате отправления: