Re: pl/pgsql list as parameter.

I am still unclear of how this works. Please help! I really would appreciate this. This is what I have so far:


CREATE TYPE tp_lm_object AS(
 .....
);

CREATE OR REPLACE FUNCTION
getLMs(int[],float(8), float(8)) RETURNS SETOF tp_lm_object AS $$
DECLARE
    myrec record;
    requestIds ALIAS for $1;
    latitude ALIAS for $2;
    longitude ALIAS for $3;
BEGIN
   FOR myrec IN SELECT
   LMID,  LMOrigin ,LMType
   FROM locationMessages
   WHERE LMID IN (requestIDs) LOOP RETURN NEXT myrec; END LOOP; RETURN; END;    
$$ LANGUAGE 'plpgsql';

I have two question

1) how do you call an pgsql function from command line when your function takes an int array?
2) Will the above work. I am not sure, since I think I have to loop twice, one for the myrec and one for the int[]. Can anybody please shed light on this.
3) How do you call a method like this using the CallableStatement in JDBC. I cannot seem to understand how to use setArray() succesfully?

Any help would be appreciated. Much thanks.

-assad