Re: Inserting data of two other tables [Now deleting ...]

From: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
To: papapep <papapep(at)gmx(dot)net>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Inserting data of two other tables [Now deleting ...]
Date: 2003-05-26 17:55:28
Message-ID: 1053971728.699.4.camel@billy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Am Mon, 2003-05-26 um 19.38 schrieb papapep:

DELETE ... FROM ... WHERE

e.g.:

DELETE FROM a WHERE datum='17.07.1999'::date AND NOT EXISTS (SELECT NULL
FROM b WHERE b.field=a.field);

or something like that

HTH
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Rory Campbell-Lange 2003-05-26 18:21:33 add foreign key constraint after table creation?
Previous Message papapep 2003-05-26 17:38:21 Re: Inserting data of two other tables [Now deleting ...]