stupid select question... - Mailing list pgsql-general

From Konstantinos Agouros
Subject stupid select question...
Date
Msg-id 20010114115740.B8902@rumba.agouros.de
Whole thread Raw
Responses Re: stupid select question...  ("Oliver Elphick" <olly@lfix.co.uk>)
List pgsql-general
Hi,

my sql has gotten a little rusty, here's what I want to do:
I have two tables both contain urls. How what I want are all the entries in
table b where there is no matching url in table a. I do remember doing something
like this with a
select url from table1 where a.url not in select url from table b.

Can I do this in postgres?

Konstantin
--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood@agouros.de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not sustain the forming of the cosmos." B'Elana Torres

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: fatal error - different CATALOG_VERSION_NO
Next
From: Peter Eisentraut
Date:
Subject: Re: performance hit with --enable-debug