Hi, i m developing a store procedure that accepts an array of rows, this is the simplified code:
http://pastebin.com/wC92Dh7f
Please note that i left out everything that is not related, in the function, to the problem at hand, only the code related to my problem is included.
The above does not allow me to access the members of the rows in the array, this is how i call this function:http://pastebin.com/wC92Dh7f
Please note that i left out everything that is not related, in the function, to the problem at hand, only the code related to my problem is included.
select ret,username,password from wtt_add_account('2802021','JPL123','1','3',ARRAY[row('1','25','10')::wtt_balance_info_t,row('2','50','15')::wtt_balance_info_t]);
CREATE TYPE wtt_balance_info_t AS (balanceid varchar(25),chgval varchar(25),servicestop varchar(25)) .