Timeline for Running a CTE query in a loop using PL/pgSQL
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 23, 2017 at 12:40 | history | edited | CommunityBot |
replaced http://stackoverflow.com/ with https://stackoverflow.com/
|
|
| Oct 4, 2012 at 19:51 | comment | added | sm90901 | Took care of the problems I mentioned and added the coordinate_id's, my bad design decision caused it to run slow. Many thanks for all your help, I think I'll delve deeper into the concepts of databases and performance tuning as soon as this project of mine is wrapped up. | |
| Sep 28, 2012 at 7:46 | vote | accept | sm90901 | ||
| Sep 28, 2012 at 3:25 | history | edited | Erwin Brandstetter | CC BY-SA 3.0 |
cleanup
|
| Sep 28, 2012 at 2:27 | history | migrated | from stackoverflow.com (revisions) | ||
| Sep 28, 2012 at 0:28 | comment | added | Erwin Brandstetter |
@sm90901: Fixed a typo: c.coordinates_id -> q.coordinates_id. I am assuming here, you want to identify coordinates in the result. Maybe not, then you don't need it. Maybe you even want to aggregate over all coordinates, then remove c.coordinates_id from the CTE, too. But your original query indicated otherwise ...
|
|
| Sep 28, 2012 at 0:21 | vote | accept | sm90901 | ||
| Sep 28, 2012 at 7:46 | |||||
| Sep 27, 2012 at 16:40 | history | answered | Erwin Brandstetter | CC BY-SA 3.0 |