I need to write a postgresql query, can you help me?

Question

PHP

Now I have a request

"SELECT id, extract(epoch from (now() - create_time::timestamp)) FROM ::users WHERE lastvisit IS NULL"

, Then I

foreach ($query as $value)
if ($value['date_part']>86400*3) \DB::query("DELETE FROM ::users WHERE id=?",[$value[id]]);

Is it possible to do all this with one request?

Answer 1

Delete all users with lastvisit NULL and create_time greater than 3 days ago?
Well, why is it so difficult?

delete from users where lastvisit IS NULL and create_time < now() - interval '3 day'