Re: [SQL] pgsql and cursor

[Ian Lance Taylor]

Najm Hashmi <[EMAIL PROTECTED]> writes:

> Hi all, I am not sure If it is allowed to use cursor inside pgsql functions.
> If it is possible, please someone could send exact synatx  how it is used. If
> it is not allowed  is there a way arround it? I need to do some calculations
> and then return this value as text.

Cursors are not supported in PL/pgSQL.  (You can, however, use FOR to
loop over a query).

For a patch to add cursor support to PL/pgSQL, see
    http://www.airs.com/ian/pgsql-cursor.html

Ian