From: | pgsql-bugs(at)postgresql(dot)org |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Bug #668: cursors with params: mismatched parentheses; |
Date: | 2002-05-20 18:05:52 |
Message-ID: | 20020520180552.285E14759DF@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Eduardo Rambo (rambo(at)portoweb(dot)com(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | pgsql-bugs | 2002-05-20 20:18:05 | Bug #669: gawk: cmd. line:2: (END OF FILE) |
Previous Message | Tatsuo Ishii | 2002-05-20 08:25:07 | Re: [HACKERS] Bug #659: lower()/upper() bug on |