In dart, I turn my

DataModel

into a json document using a

toMap()

method defined by me. I pass that document to the insert statement like this:

dart
addTransaction(DataModel data) {
    var response = _databaseService
        .insert(
          data.toMap(),
        )
        .execute();
    return response;
  }

I want to do the same thing but in a

Stored Procedure

like this:

dart
addTransaction(DataModel data) {
    var response = _databaseService
        .rpc(
          data.toMap(),
        )
        .execute();
    return response;
  }

What would be the name of the object type while defining this function? I cannot find json in the intellisense. The reason I want to do this is to be able to add some data from the json document in one table and the rest of the data in another table in one go.

Hello @Muezz! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

which exact function do you mean? In

dart

or in

postgres

?

wubba_lubba_whatever (2022-04-16)

I mean the

Stored Procedure

that can be executed directly from dart using the

rpc

command i.e. the one written in

plpgsql

lemme see

Doesn't need your dart code the name of the function? You only pass the arguments.

yes. But when I am defining the function within Supabase, I have to explicitly tell the type of the argument it will be getting.

I know, but

jsonb

is listed there, isn't it?

currently I am trying to test the function directly in the SQL Editor and the intellisense doesnt show

jsonb

try nevertheless. It will throw a type on function creation, if it doesn't exist

I am trying to check. gimme a couple mins

Are you interpreting the error message that way?

What do you mean?

the error comes from line 10 ( I guess, because you cannot return a table that way)

I think the error comes from line 8 because sql thinks that it is a variable that should have been declared earlier and it is not. It does not know that it is a table because I did not insert using the conventional method.

I think that's the answer https://stackoverflow.com/a/26742370

This did not work too