function parameter as array?

[djam]

Is it possible to pass an array in a functin call? also is there loops in functions?

I would like to do something like this...

eg.
create function sumPrice ([array of id ints]) return int4 AS ' --loop the size of the array and sum the Price of each id, then return the sum 'LANGUAGE' sql';


any examples would be helpful

thanks
" ahhh computers, how they made our lives much simpler "

 

[djam]

sorry, for the previous question the LANGUAGE should not be sql because sql doesn't have loops I would like to use postgres

thanks " ahhh computers, how they made our lives much simpler "