On Tuesday, September 4, 2012 5:59:00 PM UTC-7, François Beausoleil wrote: > > Hi! > > Just wondering if I can express the above statement using pure Sequel? > > I tried DB[:t1].insert(DB[:t2]) but that does INSERT INTO t1 SELECT * FROM > t2, and fails because t2 doesn't exist. I don't know the exact number / > types of columns at the point of call, because I'm higher up in my > abstractions. > > Assuming you are trying to create a table as the result of a query, you want:
DB.create_table(:t1, :temp=>true, :as=>DB[:t2]) Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/sequel-talk/-/tHd6ZFB2qn0J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
