* Mike Benoit <[EMAIL PROTECTED]> [2004-10-07 11:47:50 -0700]: > I assume I'm not the first person to run in to this, however > searching google didn't seem to come up with anything useful.
AFAICT, the first query is just constructed poorly, while the second seems to recurse on itself. The order in the sub-selects doesn't seen necessary either. > its=> begin; delete from pay_stub_entry where pay_stub_id in (select > id from pay_stub where created_date >= 1096527603 order by > created_date desc); DELETE FROM pay_stub_entry JOIN pay_stub ON (pay_stub_entry.pay_stub_id = pay_stub.id) WHERE pay_stub.created_data >=1096527603; > delete from pay_stub where id in (select id from pay_stub where > created_date >= 1096527603 order by created_date desc); commit; DELETE FROM pay_stub WHERE created_data >=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
