plpgsql Cursor Mismatched Parentheses

Hi!

I have never successfully used bounded parameterized
cursors. Error occurs when opening cursor. Please see
below and help!

Regards,

CN
===========================
CREATE FUNCTION test(SMALLINT,SMALLINT) RETURNS
BOOLEAN AS '
DECLARE
  y1 ALIAS FOR $1;
  m1 ALIAS FOR $2;

  o TEXT;
  y2 SMALLINT;
  m2 SMALLINT;

  c CURSOR (o TEXT,y1 SMALLINT,m1 SMALLINT,y2
SMALLINT,m2 SMALLINT) IS
  SELECT column1,column2 FROM table1 WHERE column9=o
AND column3 BETWEEN (SELECT column3 FROM table1 WHERE
column9=o AND column1=y1 AND column2=m1) AND (SELECT
column3 FROM table1 WHERE column9=o AND column1=y2
AND column2=m2) ORDER BY 1,2;

BEGIN
  o:=''xxx'';
  y2:=2002;
  m2=7;

  OPEN c(o,y1,m1,y2,m2);
  CLOSE c;

  RETURN TRUE;
END;' LANGUAGE 'plpgsql';
======================
database=# select test(2002,5);
NOTICE:  plpgsql: ERROR during compile of test near
line 17
ERROR:  mismatched parentheses

--------------------------------------------------------
You too can have your own email address from Eurosport.
http://www.eurosport.com