Bug with cursor declaration in PL/pgSQL in CVS tip? - Mailing list pgsql-hackers

From Michael Paesold
Subject Bug with cursor declaration in PL/pgSQL in CVS tip?
Date
Msg-id 019e01c5b868$d4629ff0$0f01a8c0@zaphod
Whole thread Raw
List pgsql-hackers
I have used to declare cursors in the DECLARE section of a PL/pgSQL 
function. The example here seems to be broken in CVS tip:

CREATE FUNCTION test () RETURNS void AS '
DECLARE  credit_cursor CURSOR (p_account integer, p_reference integer) FOR   SELECT * FROM booking     WHERE
account_id=p_accountAND reference=p_reference       AND unassigned_amount = amount AND amount > 0 AND side=''credit''
   AND position_closed AND type NOT IN (''RC'', ''RP'')   ORDER BY journal_id ASC;
 
BEGIN
END
'
LANGUAGE PLPGSQL;

I get:
ERROR:  syntax error at or near "," at character 237
LINE 9:   credit_cursor CURSOR (p_account integer, p_reference integ...


The same function works perfectly well in 7.4.8 and 8.0.3.
A bug?

Best Regards,
Michael Paesold 



pgsql-hackers by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: parameterized fetch
Next
From: Tatsuo Ishii
Date:
Subject: inverse OR distributive law?