Resource embedding on an RPC function

[BorislavZlatanov]

I have an RPC function endpoint that looks like this (simplified):

CREATE FUNCTION poll()
RETURNS TABLE (post_title TEXT)
AS $$

SELECT post_title
FROM polls p
ORDER BY p.created DESC;
      
$$
LANGUAGE SQL
STABLE;

I want to do a JOIN with another table in order to filter the results based on a column from that other table.

The docs on Resource Embedding state that "For table-valued functions, it generates a join condition based on the foreign key columns of the returned table type". But I don't exactly understand what this means (what foreign key columns are in this context).

I tried the obvious thing with https://localhost/rpc/poll?select=post_title,poll_choices(id)

i.e. I tried to join a poll_choices table which has a foreign key but this foreign key is to another table, not to the table returned by the function. So I got the error Could not find a relationship between 'record' and 'poll_choices' in the schema cache

How can I accomplish my objective?

[steve-chavez]

@BorislavZlatanov Change the return type from RETURNS TABLE (post_title TEXT) to RETURNS SETOF polls and then the request should work. For this you'll also need to change to SELECT * inside the function.