© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
4 replies
Nin

Function syntax error

CREATE OR REPLACE FUNCTION public.handle_sign_up()
    RETURNS trigger
    LANGUAGE 'plpgsql'
    COST 100
    VOLATILE NOT LEAKPROOF SECURITY DEFINER
AS $BODY$
BEGIN
  if new.raw_user_meta_data->>'user_type' = 'carer' then
    insert into public.carers (user_id, level, status, application_status)
    values (new.id, 0, 0, 'registered');
    return new;
  else if new.raw_user_meta_data->>'user_type' = 'client' then
    insert into public.clients (user_id)
    values (new.id);
    return new;
  else
    RAISE EXCEPTION 'Invalid user type: %', new.raw_user_meta_data->>'user_type';
  end if;
  return null;
END;
$BODY$;
CREATE OR REPLACE FUNCTION public.handle_sign_up()
    RETURNS trigger
    LANGUAGE 'plpgsql'
    COST 100
    VOLATILE NOT LEAKPROOF SECURITY DEFINER
AS $BODY$
BEGIN
  if new.raw_user_meta_data->>'user_type' = 'carer' then
    insert into public.carers (user_id, level, status, application_status)
    values (new.id, 0, 0, 'registered');
    return new;
  else if new.raw_user_meta_data->>'user_type' = 'client' then
    insert into public.clients (user_id)
    values (new.id);
    return new;
  else
    RAISE EXCEPTION 'Invalid user type: %', new.raw_user_meta_data->>'user_type';
  end if;
  return null;
END;
$BODY$;


I'm not sure why but if I try to get this function in my Supabase it errors with:

syntax error at or near ";"
syntax error at or near ";"


What am I doing wrong?
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Syntax problem with COPY function
SupabaseSSupabase / help-and-questions
4y ago
RLS Policy Syntax Error
SupabaseSSupabase / help-and-questions
3y ago
Syntax error in postgress functions
SupabaseSSupabase / help-and-questions
4y ago
syntax error at or near boolean
SupabaseSSupabase / help-and-questions
4y ago