pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew - Supernews <andrew+nonews@supernews.com>
To: pgsql-sql@postgresql.org
Subject: Re: Parameterized views proposition
Date: Sat, 12 Mar 2005 19:18:25 -0000
Message-ID: <slrnd36g41.3a6.andrew+nonews@trinity.supernews.net> (raw)
References: <A66A11DBF5525341AEF6B8DE39CDE77008804C@black.aprote.com>
	<20050312163457.GC22317@wolff.to>

On 2005-03-12, Bruno Wolff III <bruno@wolff.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



view thread (9+ messages)  latest in thread

Message-ID: <slrnd36g41.3a6.andrew+nonews@trinity.supernews.net>
Permalink:  ../slrnd36g41.3a6.andrew+nonews@trinity.supernews.net/
Also on:    postgresql.org/message-id/slrnd36g41.3a6.andrew+nonews@trinity.supernews.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: andrew+nonews@supernews.com
  Subject: Re: Parameterized views proposition
  In-Reply-To: <slrnd36g41.3a6.andrew+nonews@trinity.supernews.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox