stupid select question...

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(at)agouros(dot)de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not sustain the forming of the cosmos." B'Elana Torres