Supabase has some good examples on their website, search for hybrid search. I needed to tune the function they have there but it should show you how to approach it.