ยฉ 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabaseโ€ข4y agoโ€ข
9 replies
Deleted User

operator does not exist uuid = text

I'm trying to query a database using the following:
const { data: invite, error } = await supabase
    .from('invites')
    .select('*')
    .eq('code', params.code)
    .single()
const { data: invite, error } = await supabase
    .from('invites')
    .select('*')
    .eq('code', params.code)
    .single()

params.code is a uuid grabbed from the URL, but I run into the following issue. It seems to think it's a mismatch type? Anyone know why this is happening and how to fix it?
{
  code: '42883',
  details: null,
  hint: 'No operator matches the given name and argument types. You might need to add explicit type casts.',
  message: 'operator does not exist: uuid = text'
}
{
  code: '42883',
  details: null,
  hint: 'No operator matches the given name and argument types. You might need to add explicit type casts.',
  message: 'operator does not exist: uuid = text'
}
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 jsonb ? uuid
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
array_to_string(text[]) does not exist.
SupabaseSSupabase / help-and-questions
4y ago