BUG #2494: SCROLL CURSOR does not worl
От | Michal Szymanski |
---|---|
Тема | BUG #2494: SCROLL CURSOR does not worl |
Дата | |
Msg-id | 200606231344.k5NDiONs013610@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #2494: SCROLL CURSOR does not worl
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 2494 Logged by: Michal Szymanski Email address: biuro@globeinphotos.com PostgreSQL version: 8.1 Operating system: Windows Description: SCROLL CURSOR does not worl Details: Function with scroll cursor cannot be compiled. ERROR: syntax error at or near "CURSOR" CONTEXT: invalid type name "SCROLL CURSOR FOR SELECT * FROM freeconet.alias WHERE mask >" compile of PL/pgSQL function "dummy" near line 3 Function that I want compile. CREATE OR REPLACE FUNCTION freeconet.dummy ( ) RETURNS INT8 AS $$ DECLARE rowvar freeconet.ALIAS%ROWTYPE; DECLARE curs1 SCROLL CURSOR FOR SELECT * FROM freeconet.alias WHERE mask>='+4850X' LIMIT 100 ; BEGIN BEGIN OPEN curs1; FETCH curs1 INTO rowvar; EXCEPTION WHEN OTHERS THEN RAISE WARNING '.... Kod bledu = %', SQLSTATE; RETURN -1; /* blad danych */ END; RAISE WARNING ' mask=%',rowvar.mask; RETURN 1; END; $$ LANGUAGE 'plpgsql' VOLATILE;
В списке pgsql-bugs по дате отправления: