Very good, much to learn. thanks I'll look up virtual row.
the one thing that comes to mind right away is the use of <curr_timestamp> and etc , in my example those were local variables, in the context of your example are these accessors i.e. for instance variables ? I guess I'm confused as to how something like curr_timestamp is holding on to the result of value of the computation/query and if will be able to simply use curr_timestamp in the same way I would a local var etc. I'm guessing my answer is in my study of virtual rows :) but thanks in advance for any pointers. -Charles On Mon, Dec 10, 2012 at 7:35 PM, Jeremy Evans <[email protected]>wrote: > On Monday, December 10, 2012 4:11:03 PM UTC-8, Charles Monteiro wrote: >> >> sounds like it could :) but when you say un_tested ? is this beta api ? >> is it available in the last stable gem release i.e. that which comes with >> "gem install sequel" > > > It probably means he just didn't test the code before posting it, but he > thinks the code is valid. It does look valid, though I'd use the virtual > row syntax: > > ds = table.filter(event_nbr: 12, event_date: Date.today). > select{[count(:*){}.as(row_cnt), > max(col1).as(curr_timestamp), > max(col2).as(entry_terminal), > max(col3).as(entry_time)]} > > Thanks, > 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/-/MCrjZJcT2t0J. > > 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. > -- Charles A. Monteiro www.monteirosfusion.com sent from the road -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. 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.
