Re: Parameterized views proposition

From: Andrew - Supernews <andrew+nonews(at)supernews(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Parameterized views proposition
Date: 2005-03-12 19:18:25
Message-ID: slrnd36g41.3a6.andrew+nonews@trinity.supernews.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 2005-03-12, Bruno Wolff III <bruno(at)wolff(dot)to> wrote:
> You need to expose the columns you want to filter on so that they can
> be used in WHERE clauses.

That doesn't help when you're doing outer joins with additional join
restrictions; the semantics of those can't be converted into additional
WHERE clauses.

--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff Hoffmann 2005-03-13 21:32:15 finding schema of table that called a trigger
Previous Message Tambet Matiisen 2005-03-12 18:00:48 Re: Parameterized views proposition