Re: how to restrict inner results in OUTER JOIN?

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Drew Wilson <amw(at)speakeasy(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: how to restrict inner results in OUTER JOIN?
Date: 2003-05-06 08:01:40
Message-ID: cjqebv0vpub80mje9gq243g3cidvfa4bnb@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 5 May 2003 21:40:10 -0700, Drew Wilson <amw(at)speakeasy(dot)net>
wrote:
>I'm trying to use a left outer join to remove rows my user doesn't have
>access permission to see.

SELECT * FROM foo f LEFT OUTER JOIN secure_group sg
ON (f.group_id = sg.group_id AND sg.group_id = 1);

Servus
Manfred

In response to

Browse pgsql-general by date

  From Date Subject
Next Message shoaib 2003-05-06 08:39:02 Re: Database server restarting
Previous Message Nigel J. Andrews 2003-05-06 07:44:05 Re: Database server restarting