gistfile1.txt

create function app.user_email_verified(u app.user) returns boolean as $$
declare
  c integer;
begin
  select into c count(user_id) from app_private.email_verification_token where user_id = u.id;
  if c = 0 then
    return true;
  else
    return false;
  end if
end
$$ language sql stable security definer;