I am trying to create a function that returns a set of rows while also joining to another table. SQL doesn't seem to like that I'm returning a setof groups. I am pretty new to SQL, so I'm not sure exactly what I am supposed to be returning here. Any help would be appreciated. The arguments taken in the function will be used later once I get this figured out, I just took out the WHERE clause to troubleshoot.
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.