Deleting 100 rows which meets certain criteria - Mailing list pgsql-general

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

pgsql-general by date:

Previous
From: Gastón Quiroga
Date:
Subject: Re: pg_dump ERROR, usename "postgres" duplicated
Next
From: svcntk
Date:
Subject: Re: esql vs libpq