Bug with cursor declaration in plpgsql? (Repost)

Поиск
Список
Период
Сортировка
Искать
От
Michael Paesold
Тема
Bug with cursor declaration in plpgsql? (Repost)
Дата
Msg-id
007301c5b8f6$b1741e90$0f01a8c0@zaphod
Список
Дерево обсуждения
Bug with cursor declaration in plpgsql? (Repost) "Michael Paesold" <mpaesold@gmx.at>
Re: Bug with cursor declaration in plpgsql? (Repost) Tom Lane <tgl@sss.pgh.pa.us>
[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_account AND 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 по дате отправления
От: Neil Conway
Дата:
От: Michael Paesold
Дата:
FAQ