Cursors in PL/pgSQL - Mailing list pgsql-hackers

From Ian Lance Taylor
Subject Cursors in PL/pgSQL
Date
Msg-id siae8pc3b7.fsf@daffy.airs.com
Whole thread Raw
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Re: Performance degradation in PostgreSQL 7.1beta3 vs
Next
From: "Robert B. Easter"
Date:
Subject: Re: [GENERAL] Slashdot and PostgreSQL