until you hit requirements that data must really be gone from the system at least you need something like DELETE FROM foo WHERE deleted < NOW() - '30 days'::ti

until you hit requirements that data must really be gone from the system at least you need something like DELETE FROM foo WHERE deleted < NOW() - '30 days'::timedelta (or whatever the correct syntax is)