I am newbie to postgres/SQL. I want to delete all rows exceeding 400 hours (10 days) and I want to limit deletion of only 100 records at a time. I was trying the following in PostgreSQL: DELETE from mytable WHERE (now() - timestamp_field > INTERVAL '400 hour' ) LIMIT 100; Looks like DELETE syntax doesn't support LIMIT. Is there any other way to achieve this? thanks Shul