sql/functions/auth.registrations_gc.sql


1
2
3
4
5
6
7
8
9
10
11

drop function auth.registrations_gc ();

create or replace function auth.registrations_gc ()
returns void
as $$
begin
    delete
    from auth.registrations
    where created < now() - interval '3 days';
end;
$$ language plpgsql;