Timeline for DISTINCT forces re-sorting of data on PostgreSQL
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 21, 2021 at 17:03 | comment | added | StasM | I tried with a single query, it ultimately leads to the same result, data set is re-sorted. I think @jjanes answer suggests why it is happening. | |
| Jul 21, 2021 at 14:58 | answer | added | jjanes | timeline score: 2 | |
| Jul 21, 2021 at 7:43 | comment | added | user1822 |
The order by inside the CTE makes no sense to me. Why don't you move that to the final select?
|
|
| Jul 21, 2021 at 6:37 | history | edited | StasM | CC BY-SA 4.0 |
added 3 characters in body
|
| Jul 21, 2021 at 6:36 | comment | added | StasM | oops made a mistake - it should be once or more, sorry for it, I've edited the text. | |
| Jul 21, 2021 at 6:35 | comment | added | ypercubeᵀᴹ | How can you get repeats when you claim that "each account can participate in a transaction only once "? | |
| Jul 21, 2021 at 6:24 | history | edited | StasM | CC BY-SA 4.0 |
added 68 characters in body
|
| Jul 21, 2021 at 6:19 | history | asked | StasM | CC BY-SA 4.0 |