Postgres Pro
Downloads
Home   >   mailing lists

Re: correlated delete with 'in' and 'left outer join' - Mailing list pgsql-general

From Mike Mascari
Subject Re: correlated delete with 'in' and 'left outer join'
Date
Msg-id 403F8656.6030704@mascari.com
Whole thread Raw
In response to Re: correlated delete with 'in' and 'left outer join'  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-general
Tree view 
Stephan Szabo wrote:

> ON conditions and WHERE conditions are different.
>
> Try
> select foo.key, bar.key from foo left outer join bar on foo.key=bar.key
> where bar.key is null;

Yep. Sorry.

Mike Mascari

pgsql-general by date:

Previous
From: Michael Chaney
Date:
Subject: Re: field must appear in the GROUP BY clause or be used in an aggregate function?
Next
From: Tom Lane
Date:
Subject: Re: field must appear in the GROUP BY clause or be used