Skip site navigation (1) Skip section navigation (2)

Re: proposal - new SPI cursor function

From: David Fetter <david(at)fetter(dot)org>
To: Pavel Stehule <pavel(dot)stehule(at)hotmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: proposal - new SPI cursor function
Date: 2007-01-03 20:53:07
Message-ID: 20070103205307.GF28334@fetter.org (view raw or flat)
Thread:
Lists: 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(at)postgresql(dot)org so that your
> >       message can get through to the mailing list cleanly
> 
> -- 
> David Fetter <david(at)fetter(dot)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(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!

In response to

Responses

pgsql-hackers by date

Next:From: Simon RiggsDate: 2007-01-03 21:13:16
Subject: Re: Execution Plan
Previous:From: David FetterDate: 2007-01-03 20:36:27
Subject: Re: proposal - new SPI cursor function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group