proposal - new SPI cursor function

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 fetch statement.

Sounds good.

Please ensure the default for PL/pgSQL remains as non-scrollable. That
may or may not be the same for plpgpsm.

--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com

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 default for PL/pgSQL remains as non-scrollable. That
may or may not be the same for plpgpsm.

Default plpgpsm cursors are non scrollable too. But I have to do two
patches. Syntax of declare section is total different. Between SQL/PSM and
plpgsql is only one big difference (in default values). SQL/PSM procedures
are flagged SECURITY DEFINER and plpgsql run wit default SECURITY CALLER.

Pavel

_________________________________________________________________
Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/

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.

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!

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!

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 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!

_________________________________________________________________
Citite se osamele? Poznejte nekoho vyjmecneho diky Match.com.
http://www.msn.cz/

"Pavel Stehule" <pavel.stehule@hotmail.com> 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, tom lane

"Pavel Stehule" <pavel.stehule@hotmail.com> 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, tom lane

It doesn't allow FETCH_ABSOLUTE

Regards
Pavel Stehule

_________________________________________________________________
Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci.
http://messenger.msn.cz/

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.

enum is better, true

I don't think we want an enum here (maybe short).

tree fields: FORWARD, BACKWARD, ABSOLUTE

I think for fetch absolute you are missing an offset argument.

Andreas