I was wanting to implement something like

create temp table t as
insert into table(a, b) select ... returning id, other, values

or using "with x as (insert ... returning ...) ..."

The Dataset#import does a good job on generating the SQL:

DB[:table].returning(...).import [...], select_dataset

But it will also execute the generated SQL while I'd like to use it to populate an auxiliar table for another batch insert :)

For the time being, I'll generate the insert myself without using import, but I'd like to hear back if I'm missing something as Sequel has lots of surprises and I'm always learning something new...

Cheers,
Rodrigo.

--
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 http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to