Re: proposal - new SPI cursor function - Mailing list pgsql-hackers

From David Fetter
Subject Re: proposal - new SPI cursor function
Date
Msg-id 20070103205307.GF28334@fetter.org
Whole thread Raw
In response to Re: proposal - new SPI cursor function  (David Fetter <david@fetter.org>)
Responses Re: proposal - new SPI cursor function  ("Pavel Stehule" <pavel.stehule@hotmail.com>)
Re: proposal - new SPI cursor function  ("Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>)
List pgsql-hackers
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_with_direction(Portal portal, int direction, long count) 
> 
> Is "int" a reasonable domain for directions?  I'd think there would be
> at most values.

Er, "at most two."

Cheers,
D
> 
> Cheers,
> D
> > where is possible set direction of fetch statement.
> 
> > 
> > any comments?
> > 
> > Regards
> > 
> > Pavel Stehule
> > 
> > _________________________________________________________________
> > Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci. 
> > http://messenger.msn.cz/
> > 
> > 
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: if posting/reading through Usenet, please send an appropriate
> >       subscribe-nomail command to majordomo@postgresql.org so that your
> >       message can get through to the mailing list cleanly
> 
> -- 
> David Fetter <david@fetter.org> http://fetter.org/
> phone: +1 415 235 3778        AIM: dfetter666
>                               Skype: davidfetter
> 
> Remember to vote!
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match

-- 
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666                             Skype: davidfetter

Remember to vote!


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: proposal - new SPI cursor function
Next
From: "Simon Riggs"
Date:
Subject: Re: Execution Plan