© 2026 Hedgehog Software, LLC

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

operator does not exist jsonb ? uuid

I am getting this exception when trying to add a policy that checks if participants are part of transaction. participant is a jsonb array string. it works if i hardcode auth.uid() though.

create or replace function public.get_transactions_for_authenticated_user( user_id uuid)
returns setof bigint
language sql
security definer
set search_path = public
stable
as $$
    select id from transactions where participants::jsonb  ? auth.uid()
$$;
create or replace function public.get_transactions_for_authenticated_user( user_id uuid)
returns setof bigint
language sql
security definer
set search_path = public
stable
as $$
    select id from transactions where participants::jsonb  ? auth.uid()
$$;

any pointers?
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

operator does not exist uuid = text
SupabaseSSupabase / help-and-questions
4y ago
function uuid_generate_v4() does not exist
SupabaseSSupabase / help-and-questions
4y ago
Function uuid_generate_v4() does not exist (SQLSTATE 42883)
SupabaseSSupabase / help-and-questions
6mo ago
relation does not exist
SupabaseSSupabase / help-and-questions
4y ago