Re: [HACKERS] proposal - new SPI cursor function

2007-01-05 Thread Zeugswetter Andreas ADI SD
> > > I am working on support scrollable cursors in plpgpsm. Scrollable cursors > > > are in ToDo for plpgsql too. I need new function > > > SPI_cursor_fetch_with_direction(Portal portal, int direction, long count) > > > > Is "int" a reasonable domain for directions? I'd think there would be

Re: [HACKERS] proposal - new SPI cursor function

2007-01-03 Thread Pavel Stehule
"Pavel Stehule" <[EMAIL PROTECTED]> writes: > I need new function > SPI_cursor_fetch_with_direction(Portal portal, int direction, long count) > where is possible set direction of fetch statement. Huh? SPI_cursor_fetch already lets you specify forward or backward. re

Re: [HACKERS] proposal - new SPI cursor function

2007-01-03 Thread Tom Lane
"Pavel Stehule" <[EMAIL PROTECTED]> writes: > I need new function > SPI_cursor_fetch_with_direction(Portal portal, int direction, long count) > where is possible set direction of fetch statement. Huh? SPI_cursor_fetch already lets you specify forward or backward. regar

Re: [HACKERS] proposal - new SPI cursor function

2007-01-03 Thread Pavel Stehule
i> > > Is "int" a reasonable domain for directions? I'd think there would be > at most values. Er, "at most two." enum is better, true tree fields: FORWARD, BACKWARD, ABSOLUTE Cheers, D > > Cheers, > D > > where is possible set direction of fetch statement. > > > > > any comments? > > >

Re: [HACKERS] proposal - new SPI cursor function

2007-01-03 Thread David Fetter
On Wed, Jan 03, 2007 at 12:36:27PM -0800, David Fetter wrote: > On Wed, Jan 03, 2007 at 06:30:48PM +0100, Pavel Stehule wrote: > > Hello, > > > > I am working on support scrollable cursors in plpgpsm. Scrollable cursors > > are in ToDo for plpgsql too. I need new function > > SPI_cursor_fetch_w

Re: [HACKERS] proposal - new SPI cursor function

2007-01-03 Thread David Fetter
On Wed, Jan 03, 2007 at 06:30:48PM +0100, Pavel Stehule wrote: > Hello, > > I am working on support scrollable cursors in plpgpsm. Scrollable cursors > are in ToDo for plpgsql too. I need new function > SPI_cursor_fetch_with_direction(Portal portal, int direction, long count) Is "int" a reaso

Re: [HACKERS] proposal - new SPI cursor function

2007-01-03 Thread Pavel Stehule
> I am working on support scrollable cursors in plpgpsm. Scrollable cursors > are in ToDo for plpgsql too. I need new function > SPI_cursor_fetch_with_direction(Portal portal, int direction, long count) > where is possible set direction of fetch statement. Sounds good. Please ensure the def

Re: [HACKERS] proposal - new SPI cursor function

2007-01-03 Thread Simon Riggs
On Wed, 2007-01-03 at 18:30 +0100, Pavel Stehule wrote: > I am working on support scrollable cursors in plpgpsm. Scrollable cursors > are in ToDo for plpgsql too. I need new function > SPI_cursor_fetch_with_direction(Portal portal, int direction, long count) > where is possible set direction o