diff options
author | Matthew Draper <matthew@trebex.net> | 2014-08-26 23:58:06 +0930 |
---|---|---|
committer | Matthew Draper <matthew@trebex.net> | 2014-08-26 23:58:06 +0930 |
commit | 36836fa5e7c084c0dce2818577e6fd0cf815f786 (patch) | |
tree | bee0543d1c859c53a0268a5b31a8af17015f28ff /README.markdown | |
parent | 53bc8426648cc93695525e8f12102cd416b2d772 (diff) | |
parent | 712c002af51700d128eb45996687600bb20c75a7 (diff) | |
download | rails-36836fa5e7c084c0dce2818577e6fd0cf815f786.tar.gz rails-36836fa5e7c084c0dce2818577e6fd0cf815f786.tar.bz2 rails-36836fa5e7c084c0dce2818577e6fd0cf815f786.zip |
Merge pull request #300 from jpcody/master
Allow for alias omission in aggregate expressions
Diffstat (limited to 'README.markdown')
-rw-r--r-- | README.markdown | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/README.markdown b/README.markdown index f12aa67498..1776330da8 100644 --- a/README.markdown +++ b/README.markdown @@ -120,10 +120,10 @@ Aggregate functions `AVG`, `SUM`, `COUNT`, `MIN`, `MAX`, `HAVING`: ```ruby photos.group(photos[:user_id]).having(photos[:id].count.gt(5)) # => SELECT FROM photos GROUP BY photos.user_id HAVING COUNT(photos.id) > 5 -users.project(users[:age].sum) # => SELECT SUM(users.age) AS sum_id FROM users -users.project(users[:age].average) # => SELECT AVG(users.age) AS avg_id FROM users -users.project(users[:age].maximum) # => SELECT MAX(users.age) AS max_id FROM users -users.project(users[:age].minimum) # => SELECT MIN(users.age) AS min_id FROM users +users.project(users[:age].sum) # => SELECT SUM(users.age) FROM users +users.project(users[:age].average) # => SELECT AVG(users.age) FROM users +users.project(users[:age].maximum) # => SELECT MAX(users.age) FROM users +users.project(users[:age].minimum) # => SELECT MIN(users.age) FROM users users.project(users[:age].count) # => SELECT COUNT(users.age) FROM users ``` @@ -201,7 +201,7 @@ users. project(users[:id], cte_table[:click].sum). with(composed_cte) -# => WITH cte_table AS (SELECT FROM photos WHERE photos.created_at > '2014-05-02') SELECT users.id, SUM(cte_table.click) AS sum_id FROM users INNER JOIN cte_table ON users.id = cte_table.user_id +# => WITH cte_table AS (SELECT FROM photos WHERE photos.created_at > '2014-05-02') SELECT users.id, SUM(cte_table.click) FROM users INNER JOIN cte_table ON users.id = cte_table.user_id ``` When your query is too complex for `Arel`, you can use `Arel::SqlLiteral`: |