Hello. I think I need som help on this function I write in plpgsql I want to return CREATE OR REPLACE FUNCTION gList(tid_ TIMESTAMP) RETURNS AS $$ DECLARE rec RECORD; BEGIN FOR rec IN SELECT DISTINCT custid,action,nr FROM ... IF rec.action = ... END IF; RETURN NEXT ??????????????? END LOOP; RETURN; END; $$ LANGUAGE plpgsql; I want to replace the ????????? with something that will contain both rec.nr and rec.action. What should that looklike? rec.nr , rec.action ? And what should I write after RETURNS .... in the first line? RECORD? Oh, now that I write this I understand that I could replace the RETURN NEXT in the loop with a single RETURN QUERY at the end... I don't know if that will be good, but I still would like to know how to return the separate fields from the rec record.
