Re: [HACKERS] Bug with cursor declaration in plpgsql? (Repost)

2005-09-14 Thread Tom Lane
"Michael Paesold" <[EMAIL PROTECTED]> writes: > 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? Yeah, looks like Neil accidentally dropped

[HACKERS] Bug with cursor declaration in plpgsql? (Repost)

2005-09-13 Thread Michael Paesold
[Note: reposted because it didn't show up on the list after a day] 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_refere