aboutsummaryrefslogtreecommitdiffstats
path: root/README.markdown
diff options
context:
space:
mode:
authorSean Griffin <sean@thoughtbot.com>2014-10-30 12:40:41 -0600
committerSean Griffin <sean@thoughtbot.com>2014-10-30 12:40:41 -0600
commit9b92af7098b2728ced578ab9a7679176d20f120f (patch)
treec17af0e6808c757a624341644f2cb265a29e29cb /README.markdown
parent7db0e4accff919f0a7aea875fbc8d9f5696ecb69 (diff)
downloadrails-9b92af7098b2728ced578ab9a7679176d20f120f.tar.gz
rails-9b92af7098b2728ced578ab9a7679176d20f120f.tar.bz2
rails-9b92af7098b2728ced578ab9a7679176d20f120f.zip
Revert "Merge pull request #300 from jpcody/master"
This reverts commit 36836fa5e7c084c0dce2818577e6fd0cf815f786, reversing changes made to 53bc8426648cc93695525e8f12102cd416b2d772.
Diffstat (limited to 'README.markdown')
-rw-r--r--README.markdown10
1 files changed, 5 insertions, 5 deletions
diff --git a/README.markdown b/README.markdown
index 76efb2b34a..ca4772ca7a 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) 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].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].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) 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) AS sum_id 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`: