* Steven Klassen <[EMAIL PROTECTED]> [2004-10-07 12:33:34 -0700]: > DELETE FROM pay_stub_entry > JOIN pay_stub ON (pay_stub_entry.pay_stub_id = pay_stub.id) > WHERE pay_stub.created_date >=1096527603;
After RTFM'ing it appears you can't do actual joins with delete so we'll just have to daisy-chain the where clause. DELETE FROM pay_stub_entry WHERE pay_stub_entry.pay_stub_id = pay_stub.id AND pay_stub.created_date >=1096527603; -- Steven Klassen - Lead Programmer Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Replication & Support Services, (503) 667-4564 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly