I'm probably missing something obvious here but I can't quite see it.
CREATE VIEW weekly_bar_info AS
MIN(bar_date) AS earliest_date, MAX(bar_date) AS latest_date,
MIN(bar) as min_bar, MAX(bar) as max_bar
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 Makepeace .............................. http://paulm.com/inchoate/
"If they asked us nicely, then we wouldnt be as happy with it."
pgsql-novice by date
|Next:||From: Ron St-Pierre||Date: 2004-10-13 23:01:13|
|Subject: Re: VIEWs with aggregate functions|
|Previous:||From: Jake Stride||Date: 2004-10-13 21:02:21|
|Subject: Re: Data Grid|