From: | Noel Faux <noel(dot)faux(at)med(dot)monash(dot)edu(dot)au> |
---|---|
To: | Chris Velevitch <chris(dot)velevitch(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to join to delete |
Date: | 2006-05-02 07:03:09 |
Message-ID: | 4457042D.2040307@med.monash.edu.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Chris,
I think the best bet would be to use a nested select:
Delete from A WHERE A.bk = (SELECT bk FROM B) where A.ak = x;
Cheers
Noel
Chris Velevitch wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
Attachment | Content-Type | Size |
---|---|---|
noel.faux.vcf | text/x-vcard | 260 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-05-02 07:23:51 | Re: Return value (instead of reference) for user defined type |
Previous Message | Don Y | 2006-05-02 07:00:04 | Return value (instead of reference) for user defined type |