Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBD-Pg CPAN distribution.

Report information
The Basics
Id:
88195
Status:
stalled
Priority:
Low/Low
Queue:

People
Owner:
Nobody in particular
Requestors:
greg [...] turnstep.com
Cc:
AdminCc:

BugTracker
Severity:
Wishlist
Broken in:
(no value)
Fixed in:
(no value)



Subject: Allow seeking over results
From an email. Have not looked into how feasible this is: " When working in PHP with mysql or postgresql there is a function, e.g. pg_result_seek, which allows random access seek over the tuple set. The underlying libpq allows this. I don't see any equivalent method in DBD::Pg. I would prefer not to use SQL cursors or the LIMIT/OFFSET hack. So I wonder if it would be possible to add such a method, e.g. $sth->result_seek($rownum); I see that dbd_st_fetch calls PQgetvalue(imp_sth->result, imp_sth->cur_tuple, i); but there is no accessible means of modifying imp_sth->cur_tuple, only a read-only attribute. It would seem to me that a correct implementation of result_seek should also turn ACTIVE_on if the new row number is < imp_sth->rows so that it is possible to "rewind" the result stream, and it should fail if the row is
Show quoted text
>=imp_sth->rows"


This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.