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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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