Re: GROUP BY fails on Heroku
What is the PostgreSQL equivalent of Chap's code? Mine is very similar, and i cannot get it to work on PostgreSQL. Thanks in advance -- You received this message because you are subscribed to the Google Groups Heroku group. To view this discussion on the web visit https://groups.google.com/d/msg/heroku/-/reCG0_3kW-IJ. To post to this group, send email to heroku@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
Re: GROUP BY fails on Heroku
Hi Chap, Heroku uses Postgres, not MySQL, and AFAIR, Postgres doesn't allow you to do a SELECT * on a grouped argument, but only select grouped and aggregated columns - something like that anyway ;) You should install Postgres on your development machine and and test your application against a local Postgres database before deploying it to Heroku. Cheers, Casper Fabricius On 17/09/2009, at 07.16, Chap wrote: This works great locally on mysql, but gives me an error on heroku: Task.find(:all, :group = 'project_id') My goal is to find only unique records (according to the project_id column). --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Heroku group. To post to this group, send email to heroku@googlegroups.com To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~--~~~~--~~--~--~---
GROUP BY fails on Heroku
This works great locally on mysql, but gives me an error on heroku: Task.find(:all, :group = 'project_id') My goal is to find only unique records (according to the project_id column). --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Heroku group. To post to this group, send email to heroku@googlegroups.com To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~--~~~~--~~--~--~---