help with "delete joins"

From: Robert Treat <rtreat(at)webmd(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: help with "delete joins"
Date: 2003-06-30 22:26:38
Message-ID: 1057011998.24310.348.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

create table foo (a int, b int, c int, d text);

create table bar (a int, b int, c int);

insert into foo values (1,2,3,'a');
insert into foo values (1,2,4,'A');
insert into foo values (4,5,6,'b');
insert into foo values (7,8,9,'c');
insert into foo values (10,11,12,'d');

insert into bar values (1,2,3);
insert into bar values (7,8,9);
insert into bar values (10,11,12);

what i want to do is:

delete * from foo where not (foo.a = bar.a and foo.b=bar.b and
foo.c=bar.c) ;

so i end up with

postgres=# select * from foo;
a | b | c | d
---+---+---+---
1 | 2 | 4 | A
4 | 5 | 6 | b
(2 rows)

but thats not valid sql, is there some way to accomplish this?

Robert Treat

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2003-06-30 22:36:47 Re: help with "delete joins"
Previous Message Josh Berkus 2003-06-30 22:02:24 Re: cleaning up useless pl/pgsql functions