Hi,
I am trying to create a PL/PGSQL stored proc in PostgreSQL 7.3.2 on Mandrake 9.1. I keep getting a "cursor already in use" error even though I only open the cursor once, fetch using that cursor, and then close the cursor when I am finished with it. Why is this happening? I have pasted the code at <http://www.paste.msunix.org/index.php?view=3012>.
Never mind. I was invoking the stored procedure incorrectly.
Incorrect:
select fx_extract_email_address('1111') from people;
Correct:
select * from fx_extract_email_address('1111');Regards,
Clifford Ilkay Dinamis Corporation 3266 Yonge Street, Suite 1419 Toronto, Ontario Canada M4N 3P6
Tel: 416-410-3326
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
