I wrote this question on RoRTalk back in August but haven't heard back
yet:
http://tinyurl.com/4ohxdnf. So I think I must've been unclear.
Assume you have a Sale model with just a product Id and a quantity
sold. You want to see a total number of sales for each product.
Product.group(:product_id).select("product_id, sum(quantity) as
total_quantity")
Let's collect just the totals to see what they look like in irb:
Product.group(:product_id).select("product_id, sum(quantity) as
total_quantity").map(&:total_quantity)
In SQLite (and MySQL I think) I get the following:
=> [293.00, 4.00, 76.00, 9.00, 370.25, 71.00]
BUT! PostgreSQL returns this:
=> ["293.00", "4.00", "76.00", "9.00", "370.25", "71.00"]
Strings! Why strings!? Am I doing something wrong? Why is this
happening, how do I fix it, and why doesn't ActiveRecord protect poor
little me from the mean world of db inconsistencies? ;)
Thank in advance.
PS Quantity is a decimal in the schema.
--
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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
