Calling a rpc procedure with array parameters about postgrest-docs

[shanakadu]

Thanks @begriffs , it works!!.
And if it helpfull for someone. And example how to works with it.

CREATE OR REPLACE FUNCTION public.test_array(param_in json)
  RETURNS SETOF type_struct AS
$BODY$
--for test in pgsql cmd : select  * from test_array('[{"field1":3,"field2":5},{"field1":1,"field2":2}]');
--postgrest call, on body
--{
--    "param_in":[{"field1":3,"field2":5},{"field1":1,"field2":2}]
--}
declare
_rc  refcursor;
_r record;
_i type_struct;

begin
open _rc for select * from json_array_elements(test_array.param_in);
loop 
 fetch _rc into _r;
 exit when not found;

 RAISE NOTICE '%',to_json(_r.value);
_i = json_populate_record(null::type_struct, to_json(_r.value));
RAISE NOTICE 'ee %',_i;
return next _i;
end loop;
return ;
end;

[begriffs]

Not directly. You could use a named parameter of type json and then check that it's a json array and loop through it that way. Note that when you POST a payload to the /rpc/test_array endpoint you'll still need to wrap your request in an object like this:

{ "argument_name": [1,2,3,4] }

rather than sending the array directly as

[1,2,3,4]

[begriffs]

Glad you got it working! Would you consider sending a pull request to add a note about how to deal with json arrays in function arguments? I think you're not the first person to ask. Maybe add it in this section if you'd be so kind https://github.com/begriffs/postgrest-docs/blob/master/docs/api/reading.md#stored-procedures