sql/functions/auth.delete_registration.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14

drop function auth.delete_registration (
    p_hash text
);

create or replace function auth.delete_registration (
    p_hash text
)
returns void
as $$
begin
    delete from auth.registrations r
    where r.hash = ('\x' || p_hash)::bytea;
end;
$$ language plpgsql;