Cursors in PL/pgSQL

Started by Ian Lance Tayloralmost 25 years ago1 messages
#1Ian Lance Taylor
ian@airs.com

Cursors are not supported in PL/pgSQL. I don't see a TODO item to fix
this.

Fixing the syntax to support cursors is easy. The problem then is
that PL/pgSQL uses SPI, and SPI does not support cursors. In spi.c
there is a bit of code for cursor support, with the comment
/* Don't work currently */

Is adding cursor support to SPI a bad idea? Is adding cursor support
to PL/pgSQL undesirable?

Can anybody sketch the problems which would arise when adding cursor
support to SPI?

Thanks.

Ian