Re: GROUP BY fails on Heroku

[David Zhu]

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

[Casper Fabricius]

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