Timeline for postGIS SQL request with aggregating ST_Union()
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 9 at 15:28 | comment | added | Istopopoki | Look at this: There is another important concept associated with window functions: for each row, there is a set of rows within its partition called its window frame. Some window functions act only on the rows of the window frame, rather than of the whole partition...keep reading here postgresql.org/docs/current/tutorial-window.html | |
| May 8 at 14:01 | comment | added | Momchill | @Istopopoki, the link you provided is broken, do you mind elaborating, as I am also struggling with the same issue and I have a feeling this is the missing piece of the puzzle, but simply ordering by my values, doesn't do the trick. thanks! | |
| Sep 4, 2015 at 16:18 | comment | added | Istopopoki | hmm the fact that the partition ranges ~by default~ between the first and the current row ~only when~ a order by statement is added is tricky ! inovia.fr/window-functions-basics explains it very well. | |
| Sep 4, 2015 at 15:58 | comment | added | Istopopoki | That's working perfectly, thank you so much ! No I need to understand the magic behind this, I don't even see the condition on the value. I didn't know about window function, I will have a look. Thanks again. | |
| Sep 4, 2015 at 15:56 | vote | accept | Istopopoki | ||
| Sep 4, 2015 at 14:38 | history | edited | Redoute | CC BY-SA 3.0 |
tested, works for me
|
| Sep 4, 2015 at 14:14 | history | answered | Redoute | CC BY-SA 3.0 |