Hello! According to the documentation on *Bound Variables* (https://github.com/jeremyevans/sequel/blob/master/doc/prepared_statements.rdoc), when using those, the developer should invoke #call on a Dataset instance, which is equivalent to Dataset#all, returning an array with the results.
I was wondering if it is somehow possible to use Bound Variables but keeping an instance of Dataset, so that I can later use #paged_each (http://sequel.jeremyevans.net/rdoc/classes/Sequel/Dataset.html#method-i-paged_each) to process the results lazily. I've been trying to find a solution for a couple of days now. When trying prepared statements on PostgreSQL, I haven't had any luck with querying like this: DB["EXECUTE my_prep_stmt (...)"] This is the error thrown: Sequel::DatabaseError: PG::SyntaxError: ERROR: syntax error at or near "EXECUTE" LINE 1: ..."sequel_cursor" NO SCROLL CURSOR WITHOUT HOLD FOR EXECUTE my_prep_stmt... Thanks in advance. Ricardo -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
