> by doing some research on Google, I found out that it's a DB Engin > problem. MySql allows me to do it but PostgreSql does not. > > How can I run the same query on PostgreSql.
I've run into such problem when I changed from MySQL to PostgreSQL some time ago. basically MySQL is to databases what php is to programming languages, i.e: it's permissive. I guess your query is not fully SQL compliant, but MySQL let's you get away with it whereas PostgreSQL complains and wants a legit query. -- 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 rubyonrails-t...@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.