Re: The most efficient way to put this?

From: rolf(dot)ostvik(at)axxessit(dot)no
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: The most efficient way to put this?
Date: 2002-03-05 12:58:44
Message-ID: OFBB392D4A.09D3DEE3-ONC1256B73.0045D05D@axxessit.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2002-03-05 "Arsalan Zaidi" <azaidi(at)directi(dot)com> wrote

>SELECT DISTINCT ON (aa.a) aa.a, aa.b, aa.c FROM aa WHERE aa.a NOT IN
(select
>zz.a from zz);

Does this work?

select distinct on (aa.a) aa.a, aa.b, aa.c
from aa left join zz on aa.a = zz.a
where zz.a isnull

--
Rolf

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2002-03-05 13:45:59 Re: Newbie question re SQL
Previous Message Jean-Michel POURE 2002-03-05 12:58:04 Re: The most efficient way to put this?