Bug with cursor declaration in plpgsql? (Repost)
| От | Michael Paesold |
|---|---|
| Тема | Bug with cursor declaration in plpgsql? (Repost) |
| Дата | |
| Msg-id | 007301c5b8f6$b1741e90$0f01a8c0@zaphod обсуждение исходный текст |
| Ответы |
Re: Bug with cursor declaration in plpgsql? (Repost)
|
| Список | pgsql-hackers |
[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_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 по дате отправления: