How can I cast a variable I'm sending to an RPC (function)

[nruffilo]

I have a function with the signature: CREATE OR REPLACE FUNCTION CompleteQuest(questId bigint)
The problem is, when I run it using .rpc("CompleteQuest", {questId: completedQuestId}) I get "No function matches the given name and argument types. You might need to add explicit type casts.","details":null,"code":"42883","message":"function public.CompleteQuest(questId => text) does not exist"

the completedQuestId is an INT. I've tried creating a new variable and using parseInt() but it always seems to send as text. How can I mark what the variable type is that I'm passing? Or, in the function, do I need to assume only text will be passed and cast it in the PL/SQL?

Thank you!

Additional info:

The param is being sent as an INT, but somewhere the RPC is casting it as TEXT.

[steve-chavez]

You need to double quote the function name if you use a camel case identifier, like:

CREATE OR REPLACE FUNCTION "CompleteQuest"("questId" bigint)

Otherwise postgres will convert the identifier to lowercase.

(Also quote the parameter names if they have uppercase chars)

[nruffilo]

Thank you - that did the trick. I appreciate your quick and complete response.