MOVE FORWARD IN cur;

ERROR:  parser: parse error at or near "$1" at character 18

WARNING:  Error occurred while executing PL/pgSQL function getcreative
WARNING:  line 21 at SQL statement

ERROR:  parser: parse error at or near "CURSOR" at character 22

WARNING:  plpgsql: ERROR during compile of getcreative near line 5

CREATE OR REPLACE FUNCTION "public"."getcreative2" (bigint, bigint, varchar, bigint) RETURNS bigint AS

DECLARE
  RowCount int8;
  i int8;
  res creative.creative_id%TYPE;
  cur CURSOR FOR
    SELECT g.creative_id
    FROM getcreative( $ 1 , $ 2 , $ 3 , $ 4 ) as g;
BEGIN
  OPEN cur;
  RowCount :=  0 ;
  FETCH cur INTO res;
  WHILE FOUND LOOP
    RowCount := RowCount+ 1 ;
    FETCH cur INTO res;
  END LOOP;
  RowCount := round(RowCount*random());
  MOVE BACKWARD RowCount IN cur;
  FETCH cur INTO res;
  CLOSE cur;
  return res;
END;

LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;

ERROR:  parser: parse error at or near "$1" at character 18
WARNING:  Error occurred while executing PL/pgSQL function getcreative2
WARNING:  line 21 at SQL statement

ERROR:  parser: parse error at or near "CURSOR" at character 22
WARNING:  plpgsql: ERROR during compile of getcreative2 near line 5

CREATE OR REPLACE FUNCTION "public"."getcreative" (bigint, bigint, varchar, bigint) RETURNS SETOF bigint AS'
...
очень большой запрос
...
'LANGUAGE 'sql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;