Paul Makepeace wrote:
>I'm probably missing something obvious here but I can't quite see it.
> 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.)
Can't you just SELECT * FROM weekly_bar_info WHERE bar_name = ? AND
earliest_date >= ?
or elimate the view and query directly from the table:
MIN(bar) as min_bar, MAX(bar) as max_bar
WHERE valid_weekly='t' AND bar_name = ? AND bar_date BETWEEN ? AND ?
GROUP BY bar_name
In response to
pgsql-novice by date
|Next:||From: Ron St-Pierre||Date: 2004-10-13 23:06:32|
|Subject: Re: Data Grid|
|Previous:||From: Paul Makepeace||Date: 2004-10-13 22:39:42|
|Subject: VIEWs with aggregate functions|