SPI cursor functions

From: "Tim Keitt" <tkeitt(at)keittlab(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: SPI cursor functions
Date: 2008-10-24 21:33:27
Message-ID: 6262c54c0810241433m5d30c4d6m9c31e6ccefa2d30e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The docs for FETCH indicate you can fetch from the current row using
FORWARD 0, but

SPI_scroll_cursor_fetch(someportal, FETCH_FORWARD, 0);

fails for me. Is there a way to emulate FETCH FORWARD 0 with SPI?

Also, I noticed that

SPI_scroll_cursor_move(someportal, FETCH_BACKWARD, 1);

sets SPI_processed to 0, not 1. Is that the intended behavior? How
does one check for a failed backwards move?

Thanks.

THK

--
Timothy H. Keitt
University of Texas at Austin http://www.keittlab.org/
Contact info and schedule at http://www.keittlab.org/~tkeitt/
Publications http://www.keittlab.org/biblio

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Guillaume Lelarge 2008-10-24 22:02:25 Re: WIP : change tablespace for a database
Previous Message Charles Duffy 2008-10-24 20:12:22 Re: Making pg_standby compression-friendly