Hey I have another function question. Do they not support selecting count() in them? I have a query to select count that works in the query editor, but trying to create a function for it gives me an error saying syntax error at or near SELECT. Here's the query:

SELECT COUNT(*) as row_count
FROM public.article_comments
WHERE article_comments.article_id = 2 AND
article_comments.deleted <> true;

So now you probably are hitting RLS. The API checks RLS, the sql window does not.

ah so you need to add RLS to functions too, not just tables?

If you want to avoid RLS, and it is safe to do so in your function, you can use security definer to ignore RLS.

Oh okay cool.