Message-ID: <43EA3445.9050401@obviously.com>
Date: Wed, 08 Feb 2006 10:11:17 -0800
From: Bryce Nesbitt <bryce1@obviously.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.12) Gecko/20050921
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
CC: Markus Schaber <schabi@logix-tt.com>
Subject: Re: Delete with join -- deleting related table entries?
References: <144D12D7DD4EC04F99241498BB4EEDCC20CC56@nelson.osl.com>
	<43EA2D5D.6000304@obviously.com> <43EA3082.1010804@logix-tt.com>
In-Reply-To: <43EA3082.1010804@logix-tt.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Markus Schaber wrote:
> Hi, Bryce,
>
> Bryce Nesbitt wrote:
>
>   
>> BEGIN;
>>   DELETE FROM note WHERE issue_id IN (SELECT issue_id FROM isuse
>>      WHERE reservation_id IN
>>      (select reservation_id from reservations where date > magic)
>>      );
>>   DELETE FROM isuse WHERE reservation_id IN
>>      (select reservation_id from reservations where date > magic);
>>   DELETE FROM reservations WHERE reservation_id IN
>>      (select reservation_id from reservations where date > magic);
>> COMMIT;
>>
>> I suppose I can do the subselect as a perl wrapper, but I was thinking
>> that maybe SQL could do it all for me....
>>     
>
> Why do you think this won't work? (provided you add the missing ) and ; :-)
>   
Wow.  It worked.  Cool.  I guess the reservations don't get deleted
until they are not needed any more...

Not the fastest thing in the world.  But it worked.