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 at most

[HACKERS] proposal - new SPI cursor function

2007-01-03 Thread Pavel Stehule
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) where is possible set direction of fetch statement. any comments? Regards Pavel

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 of

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

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 reasonable

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

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? Regards Pavel

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. regards,

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. regards,