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 -~----------~----~----~----~------~----~------~--~---
