Skip Menu |
 

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

Report information
The Basics
Id: 88195
Status: stalled
Priority: 0/
Queue: DBD-Pg

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

Bug Information
Severity: Wishlist
Broken in: (no value)
Fixed in: (no value)



Subject: Allow seeking over results
Download (untitled) / with headers
text/plain 855b
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 is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

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