© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
1 reply
dunston

Changed column type broke filtering

Hi I changed a column type on table with existing data from int8 to text but now I get this error when trying to filter:
{
  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: text = bigint'
}
{
  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: text = bigint'
}

this used to work fine before:
  let { data, error } = await supabase
    .from('new-follows')
    .select('username,follow_by,twit_id')
    .eq('follow_by', 239518063);
  let { data, error } = await supabase
    .from('new-follows')
    .select('username,follow_by,twit_id')
    .eq('follow_by', 239518063);

but now this gives the error above:
  let { data, error } = await supabase
    .from('new-follows')
    .select('username,follow_by,twit_id')
    .eq('follow_by', '239518063');
  let { data, error } = await supabase
    .from('new-follows')
    .select('username,follow_by,twit_id')
    .eq('follow_by', '239518063');
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

filtering on not selected column on aggregate solution
SupabaseSSupabase / help-and-questions
8mo ago
filtering key from a jsonb column that is not null
SupabaseSSupabase / help-and-questions
4y ago
Migration on hosted not changing column type
SupabaseSSupabase / help-and-questions
3w ago
Gen incorrectly marking column type as `unknown`
SupabaseSSupabase / help-and-questions
4y ago