Timeline for PostGIS- slow spatial UPDATE queries on 50mil rows
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 10, 2021 at 7:14 | comment | added | Leon Powałka |
If you want a custom value then add case when exists (...) then
|
|
| Feb 10, 2021 at 7:13 | comment | added | Leon Powałka | The boolean result is casted to int so it matches the logic you explained in the post. 1 for true and 0 for false. | |
| Feb 10, 2021 at 0:16 | comment | added | Theo F | thanks I will try that single iteration statement. Would that populate the columns with 1s in that example? What if I wanted to set some custom integers for some of the UPDATEs, like '50', or '95' for instance...? | |
| Feb 9, 2021 at 22:59 | history | edited | Leon Powałka | CC BY-SA 4.0 |
added 14 characters in body
|
| Feb 9, 2021 at 22:53 | history | edited | Leon Powałka | CC BY-SA 4.0 |
added 2 characters in body
|
| Feb 9, 2021 at 22:35 | history | answered | Leon Powałka | CC BY-SA 4.0 |