Rob Nichols wrote: > I think this SQL would do it: > > SELECT * > FROM `states` > WHERE created_at < '2010-04-16' > OR created_at = ( > SELECT created_at > FROM `states` > ORDER BY created_at ASC > LIMIT 1) > ORDER BY created_at DESC > LIMIT 1 > > But your original solution would be easier to maintain!
Thanks rob. It didn't occur to me that my fallback option will always just be the one with the lowest created_at, rather than the one after a given time (since we already established that there aren't any before the time with the first option). cheers, max -- Posted via http://www.ruby-forum.com/. -- 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
