Hi, I have created a custom composite type in Instance schema and used it as parameter for function in my application. how to pass instance of type to Execute section of function settings in builder? Rei3 complain it is invalid.
because my nested type is long and complicated id didn't bring it here but it is something like this:
create type tran_code_input as
(
tran_code_id uuid,
code text,
description text,
metadata text,
params instance.param_definition_input[],
transaction instance.tran_code_transaction_input,
entries instance.tran_code_entry_input[]
);
create type param_definition_input as
(
name text,
type integer,
"default" text,
description text
);
create type tran_code_entry_input as
(
entry_type text,
account_id text,
layer text,
direction text,
units text,
currency text,
description text,
metadata text,
condition text
);
and ...
and when i create ans instance like this :
(
tran_code_id:'12bb8c38-5b25-471a-8161-b84bf47a25c2'::uuid,
code:"Test_tranCode",
description:"this is a test for create tran code function",
.
.
.
or this :
(
'12bb8c38-5b25-471a-8161-b84bf47a25c2',
"Test_tranCode",
"this is a test for create tran code function",
"",
.
.
.
I get error that first field is not valid.