Re: correlated delete with 'in' and 'left outer join'

From: Mike Mascari <mascarm(at)mascari(dot)com>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: mike(at)linkify(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: correlated delete with 'in' and 'left outer join'
Date: 2004-02-27 18:03:02
Message-ID: 403F8656.6030704@mascari.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Chaney 2004-02-27 18:05:06 Re: field must appear in the GROUP BY clause or be used in an aggregate function?
Previous Message Michael Chaney 2004-02-27 18:01:16 Re: correlated delete with 'in' and 'left outer join'