Search Postgresql Archives

array in a store procedure in C

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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:


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]);

The type wtt_balance_info_t  is:

CREATE TYPE wtt_balance_info_t AS (balanceid varchar(25),chgval varchar(25),servicestop varchar(25)) .

I would really appreciate if someone could give me guidelines how to read/extract the rows from the array and then get each element from the rows. thank you very much!!




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux