content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: Re: Parameterized views proposition
Date: Sat, 12 Mar 2005 20:00:48 +0200
Message-ID: <A66A11DBF5525341AEF6B8DE39CDE77008804F@black.aprote.com>
Thread-Topic: Parameterized views proposition
Thread-Index: AcUnH02NbddOi0ajQh6fK+axJvmOQgAC8p3w
From: "Tambet Matiisen" <t.matiisen@aprote.ee>
To: "Bruno Wolff III" <bruno@wolff.to>
Cc: <pgsql-sql@postgresql.org>


>=20
> > Especially if you would like to put a filter on right side of left=20
> > join. Consider this query:
> >=20
> > select p.product_id, coalesce(sum(s.amount), 0)
> > from product p
> > left join sales s on p.product_id =3D s.product_id and s.date =
between=20
> > '2005-01-01' and '2005-01-31' group by p.product_id
> >=20
> > We would like to have all products listed with sum of their=20
> sales or 0=20
> > if there wasn't any. I haven't figured out so far, how to=20
> write this=20
> > query as view, so that I can set different filters at client side.
>=20
> You need to expose the columns you want to filter on so that=20
> they can be used in WHERE clauses.
>=20

Exposing columns won't solve my problem. See the previous query -
sales.date ise grouped out and can't be exposed (note that I want all
products listed, regardless if there were sales in this period or not).=20

  Tambet