Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

is it possible to return multiple rows with a postgres function rpc call? i only see the single record type

The article that you linked to is doing exactly what you are after, not sure what's not working for you? also the article is making use of a function when it would have been better to use a view.

i couldn't get it to work using  tablesample 

my function looks like this:
```
BEGIN
    SELECT array_to_json(array_agg(row_to_json(t)))
    FROM (
      SELECT name 
      FROM hashtag
      TABLESAMPLE extensions.system_rows(25)
    )t;
END;
```

i'm getting this error atm ```If you want to discard the results of a SELECT, use PERFORM instead.```

That's a syntax error. Try doing:
```sql
RETURN QUERY SELECT array_to_json...
```