Thread: pg 7.3, cursors, and prepared queries

pg 7.3, cursors, and prepared queries

From
Eric Ridge
Date:
Is it really true that prepared statements cannot be used with cursors?

PREPARE foo(int8, text) AS <some really complicated query with a
bazillion joins that takes forever to plan>;
DECLARE foo_cursor CURSOR FOR EXECUTE foo(12::int8, 'some text');
ERROR:  syntax error at or near "EXECUTE" at character 31

I've tried with 7.3, and w/ 7.4 (though I can't upgrade to 7.4 yet).

Please, say it ain't so.  Tell me I'm doing something wrong!

eric