Hello!


Apologies if this post appears repeated. I tried to post once and my 
message did not show up on the list nor in search.


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 Dataset#call, 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.

Reply via email to