Creating a function with input parameter table also used as inner join within the SQL

[accilies]

I think this is where I am stuck with Hasura... Need your assistance please. I am trying to create the below function but you can see that I am passing the comments as a parameters but I also am doing a self inner join on the comments table...

Create or replace FUNCTION users_with_top_comments(comments_row comments)
RETURNS SETOF users AS $$
select distinct(users.id) as id, users.username, users."firebaseId",count("comments".id) as plusOneRankMain, users."plusOneRankComments", users."profilePicture", users."createdOn" from users as users
inner join "public"."comments" as com on com."userId" = users.id
where users.id = comments_row.userId
group by users.id
$$ LANGUAGE sql STABLE;

I am getting the error

---

invalid reference to FROM-clause entry for table "comments".null

I feel this is because of the inner join (which I need) from the same table as that I am also passing as the paramour for the current row for the function.

Kindly advice.

[accilies]

Answering my own question.

I was having "as users" in the first select which was conflicting and secondly, the column in the comments_row needed to be quoted within ".."

Create or replace FUNCTION users_with_top_comments(comments_row comments)
RETURNS SETOF users AS $$
select distinct(users.id) as id, users.username, users."firebaseId",count("comments".id) as plusOneRankMain,
---> users."plusOneRankComments", users."profilePicture", users."createdOn" from users as users
inner join "public"."comments" as com on com."userId" = users.id
---> where users.id = comments_row.userId
group by users.id
$$ LANGUAGE sql STABLE;

CREATE OR REPLACE FUNCTION public.users_with_top_comments(comments_row comments)
RETURNS SETOF users
LANGUAGE sql
STABLE
AS $function$
select distinct(users.id) as id, users.username, users."firebaseId",count("comments".id) as plusOneRankMain,
---> users."plusOneRankComments", users."profilePicture", users."createdOn" from users
inner join comments on users.id = comments."userId"
---> where users.id = comments_row."userId"
group by users.id
$function$