update with join – another version – postgreSQL
This time its a second version of what i already posted, but might help some poor soul out there (and me, since i keep forgetting stuff). UPDATE “Patrimonio” SET x=st_x(“Morada”.geometry), y=st_y(“Morada”.geometry) FROM “Morada” WHERE “Patrimonio”.morada_id = “Morada”.”id” This example is specifically for PostgreSQL, acting on a geometry point column, but can easily, or almost directly,… Read More »