I'm writing a function which uses cursor and I have an error when executing it

[osman7king]

when executing the function as follow:
select get_pms_meeting_minute (null)

I get the follwing message:
set-valued function called in context that cannot accept a set

 
CREATE TABLE pms_meeting_minutes
(
  id_meeting_minutes integer NOT NULL,
  location character varying(50),
  date_meeting date,
  time_meeting time without time zone,
  responsible integer,
  name_meeting_minute character varying(50),
  CONSTRAINT pk_pms_meeting_minutes PRIMARY KEY (id_meeting_minutes));
 
 
create function get_pms_meeting_minute (integer) RETURNS SETOF RECORD AS'
 
DECLARE 
    ret_row RECORD;    
 
BEGIN
    IF $1 IS NULL THEN
      FOR ret_row IN SELECT *
                     FROM pms_meeting_minutes
      LOOP
        RETURN NEXT ret_row;
      END LOOP;
 
    ELSE
       IF $1 IS NOT NULL THEN
         FOR ret_row IN SELECT  * 
                        FROM pms_meeting_minutes
                        WHERE id_meeting_minutes = $1
         LOOP
           RETURN QUERY;
         END LOOP;  
       END IF;
    END IF;
END;'
 
LANGUAGE 'plpgsql'; 
 

[rski]

Maybe try calling it like that

select * from get_pms_meeting_minute (null);
 

[osman7king]

thanks a lot
it works now.