© 2026 Hedgehog Software, LLC
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$;
syntax error at or near ";"