Postgres Pro
Downloads
Home   >   mailing lists

How to join to delete - Mailing list pgsql-general

From Chris Velevitch
Subject How to join to delete
Date
Msg-id b0a3bf780605012353u7799e90av2a2bb71b0eaec41e@mail.gmail.com
Whole thread Raw
Responses Re: How to join to delete  (Noel Faux <noel.faux@med.monash.edu.au>)
Re: How to join to delete  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
I'm using pg 7.4.5 on Win XP SP1.

I want to delete rows from a table B, but need to join it to another
table A in order to select the rows in B to be deleted.

Eg. Delete from A join B on (A.bk = B.bk) where A.ak = x;

but only delete rows from B.

How do I acheive this?


Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: insert into a view?
Next
From: Don Y
Date:
Subject: Return value (instead of reference) for user defined type