| 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: | Whole Thread | Raw Message | 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
| 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 |