Arsenalist
Flop ordering by distinct column first and then by sort_by
In Flop when I have a query which uses an explicit distinct clause, then it sorts by the distinct column first, and then by the field provided by sort_by. This throws off the pagination in cursor-based pagination. How do I ensure the result sets are distinct but sorted by the sort_by field?
Marked As Solved
woylie
Postgres requires the ORDER BY clause to start with columns used in DISTINCT ON, which is why Ecto is automatically adding an order_by when you use distinct. See PostgreSQL: Documentation: 17: SELECT and Ecto.Query — Ecto v3.12.4.
You will need to wrap either the whole query or part of it in a sub query.
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Practical resources that improve the lives of professional developers. By developers, for developers.
Categories:
Sub Categories:
Forums
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Producing high quality Elixir screencasts since 2017.
Enabling companies to succeed by building software people love.
The deployment platform built for Elixir: PaaS ease, VPS control.
Courses that'll move you from confusion to "Aha, now I get it!"