From: Bryce Nesbitt <bryce1@obviously.com>
To: pgsql-sql@postgresql.org
Subject: Delete with join -- deleting related table entries?
Date: Wed, 08 Feb 2006 09:14:11 -0800
Message-ID: <43EA26E3.9040903@obviously.com> (raw)
When I delete a record from a certain table, I need to delete a
(possibly) attached note as well. How can I do this with postgres? The
tables are like this:
reservation
reservation_id
stuff...
isuse
issue_id
reservation_id
stuff..
note
issue_id
text comments...
A select that pulls out what I want to delete is:
SELECT reservation_id,issue_id,note_id,eg_note.comments FROM
eg_reservation
LEFT JOIN eg_issue USING (reservation_id)
LEFT JOIN eg_note USING (issue_id)
WHERE reservation_id > condition;
Can anyone help me turn this into a DELETE statement?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bryce1@obviously.com
Subject: Re: Delete with join -- deleting related table entries?
In-Reply-To: <43EA26E3.9040903@obviously.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox