From: | Paul Makepeace <postgresql(dot)org(at)paulm(dot)com> |
---|---|
To: | PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | VIEWs with aggregate functions |
Date: | 2004-10-13 22:39:42 |
Message-ID: | 20041013223942.GB23202@mythix.realprogrammers.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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/
From | Date | Subject | |
---|---|---|---|
Next Message | Ron St-Pierre | 2004-10-13 23:01:13 | Re: VIEWs with aggregate functions |
Previous Message | Jake Stride | 2004-10-13 21:02:21 | Re: Data Grid |