Bug #668: cursors with params: mismatched parentheses;

Поиск
Список
Период
Сортировка
От pgsql-bugs@postgresql.org
Тема Bug #668: cursors with params: mismatched parentheses;
Дата
Msg-id 20020520180552.285E14759DF@postgresql.org
обсуждение исходный текст
Ответы Re: Bug #668: cursors with params: mismatched parentheses;  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Bug #668: cursors with params: mismatched parentheses;  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-bugs
Eduardo Rambo (rambo@portoweb.com.br) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
cursors with params: mismatched parentheses;

Long Description
  cursors with parameters do not seems to work. Is that implemented?

 I tried many differents ways and get the same result:

mismatched parentheses,

no matter what table or data type the cursor is based on.

I have a linux conectiva 5 (derrived of Red Hat 7.0), and
Postgres 7.2.1.



Sample Code
create table tab_teste (codigo int primary key ,campo varchar(100));

CREATE or replace FUNCTION fteste(int)
    RETURNS numeric
    AS '
DECLARE
curs3 CURSOR (key int) IS SELECT * from tab_teste where codigo = key;
reg tab_teste%ROWTYPE;
BEGIN

OPEN curs3(1);
FETCH curs3 INTO reg;
CLOSE curs3;
RETURN 0;
END;'
    LANGUAGE 'plpgsql';

select fteste(11);

No file was uploaded with this report

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: [HACKERS] Bug #659: lower()/upper() bug on
Следующее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: Bug #669: gawk: cmd. line:2: (END OF FILE)