Re: Inserting data of two other tables [Now deleting ...] - Mailing list 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