On Mon, Jan 30, 2012 at 8:46 PM, Jayme Edwards <jayme.edwa...@gmail.com>wrote:
> Hey guys, > > I've got a table that stores events with a recurrence pattern. I found a > stored procedure that will generate occurrence dates for an event between a > start and end date. > > What I'm wondering is how to go about exploding a result set. For > instance, if I have one row for an event, but there are 5 dates it falls on > that are calculated on demand (not stored), how can I query with AREL to > return 5 events, with the same data for each field plus a new field "date" > that will contain the date of the occurrence? > > For instance, if the original table contained fields a, b, and c - the > result of this method/query would be 5 objects with fields a, b, and c - > but also one that stores the date. > Would you be able to show the raw SQL and the raw output of it (e.g. in psql or mysql) if you have that easily available? Thanks, Peter -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.