From: | Konstantinos Agouros <elwood(at)agouros(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | stupid select question... |
Date: | 2001-01-14 10:57:40 |
Message-ID: | 20010114115740.B8902@rumba.agouros.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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
From | Date | Subject | |
---|---|---|---|
Next Message | Lark | 2001-01-14 11:04:56 | Does PostgreSQL support Dynamic SQL? |
Previous Message | Dan Langille | 2001-01-14 10:27:06 | getting number of rows updated within a procedure |