Does that actually pass for you? For me it finds one event, not two.
Cheers, Lawrence > Hey guys, > > We have done another test. It is taken off Tim's code but a more > succinct example. > > https://gist.github.com/7a512dbfa945af6409b4 > > Please let me know your thoughts? > > Thanks again, > Carl. > > Carl Woodward > 0412218979 > [email protected] > > > > On Wed, Oct 7, 2009 at 10:54 AM, Lawrence Pit <[email protected]> wrote: > >> Also for date(created_at + interval '10 hours') ? >> >> LP >> >> On 07/10/2009, at 9:08 AM, Lawrence Pit <[email protected]> wrote: >> >> >> >> Both these queries will suck if you have loads of articles, as the >> function use of +date+ will prohibit the use of an index on >> created_at. >> >> Use the BETWEEN ... AND ... syntax instead, using beginning and end of >> day of local time converted to utc. >> >> >> Not true for PostgreSQL, you can create an index of date(scheduled_at) >> >> -- tim >> >> >> >> >> >> > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby or Rails Oceania" 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/rails-oceania?hl=en -~----------~----~----~----~------~----~------~--~---
