what type would you add on a Function to return all rows of a table? meaning the result of running this

SELECT * FROM users

SETOF users

(if your table is users). May need to clarify it with a schema e.g.

SETOF public.users

yes that is code wise, but what do you pick on the dropdown when creating a Function, I don't think there is a

setof

option

Oh, if you're doing it via the functions page of the dashboard, I think

record

returns the correct type

with record I get

"message":"input of anonymous composite types is not implemented","code":"0A000"

with

var users = plv8.execute(
  `select * from users`
);

return users

Why are you doing a query like that via plv8? PLV8 is basically for JS code that can run inside postgres afaik.

yes agreed, I plan to do more in there. Just trying out something basic, but I can't really get it off the ground 😦

I would honestly spend the time learning how to write function using SQL if you're planning on doing anything beyond the basics (unless you already know how to do that). For example, this works:

sql
create or replace function select_users_v8() 
returns SETOF auth.users as $$

    var num_affected = plv8.execute(
        'SELECT * FROM auth.users'
    );

    return num_affected;
$$ language plv8;

SELECT * FROM select_users_v8()