Document ordering by an alias (#3828)

elixir-ecto · Feb 2, 2022 · c149d96 · c149d96
1 parent 7750b99
commit c149d96
Showing 1 changed file with 18 additions and 0 deletions.
diff --git a/lib/ecto/query.ex b/lib/ecto/query.ex
@@ -1483,6  1483,24 @@ defmodule Ecto.Query do
         desc: c.id,
       ]
 
   It's also possible to order by an aliased or calculated column:
 
     from(c in City,
       select: %{
         name: c.name,
         total_population:
           fragment(
             "COALESCE(?, ?)   ? AS total_population",
             c.animal_population,
             0,
             c.human_population
           )
       },
       order_by: [
         {:desc, fragment("total_population")}
       ]
     )
 
   ## Expressions examples
 
       City |> order_by([c], asc: c.name, desc: c.population)