Postgres Pro
Downloads
Home   >   mailing lists

Re: how to restrict inner results in OUTER JOIN? - Mailing list pgsql-general

From Manfred Koizar
Subject Re: how to restrict inner results in OUTER JOIN?
Date
Msg-id cjqebv0vpub80mje9gq243g3cidvfa4bnb@4ax.com
Whole thread Raw
In response to how to restrict inner results in OUTER JOIN?  (Drew Wilson <amw@speakeasy.net>)
List pgsql-general
Tree view 
On Mon, 5 May 2003 21:40:10 -0700, Drew Wilson <amw@speakeasy.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

pgsql-general by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Re: Database server restarting
Next
From: "shoaib"
Date:
Subject: Re: Database server restarting