how to change return table (array of records) in rpc?

[tatiana1337]

which return type should I choose to get array of records (table) from rpc?

    let { data, error } = await supabase
        .rpc('get_posts')

this block of code returns only 1 single record from table posts

SELECT * from posts

[dshukertjr]

Hi @tatiana1337 !

Did you create the SQL function with raw SQL or from the Supabase console? Do you happen to have the definition of your get_posts function?

[tatiana1337]

Hi @tatiana1337 !

Did you create the SQL function with raw SQL or from the Supabase console? Do you happen to have the definition of your get_posts function?

hello! @dshukertjr, thanks for the reply
I have created this function in supabase console (not SQL editor, but directly in Database/Functions block) like this:
SELECT * from posts with return type "record" because there is nothing like "table" or "array" and json also didn't work

what is the proper way to add this rpc? 🙂

[steve-chavez]

The function should be declared with SETOF, like:

create or replace function get_posts() returns setof posts as $$
  select * from posts
$$ language sql