ST_UpdateZ
Signatures
GEOMETRY ST_UpdateZ(GEOMETRY geom, DOUBLE newZ);
GEOMETRY ST_UpdateZ(GEOMETRY geom, DOUBLE newZ, INT updateCondition);Description
Replaces the z-values of some or all of the coordinates of geom
by newZ.
The optional parameter updateCondition determines which
coordinates are updated:
| Value | Meaning |
|---|---|
| 1 | all z-values (by default) |
| 2 | all z-values except non-existant z-values |
| 3 | only non-existant z-values |
Examples
-- Update all z-values by default:
SELECT ST_UpdateZ('MULTIPOINT((190 300), (10 11 2))', 10);
-- Answer: MULTIPOINT((190 300 10), (10 11 10))
-- Update all z-values:
SELECT ST_UpdateZ('MULTIPOINT((190 300), (10 11 2))', 10, 1);
-- Answer: MULTIPOINT((190 300 10), (10 11 10))
-- Update all z-values except non-existant ones:
SELECT ST_UpdateZ('MULTIPOINT((190 300), (10 11 2))', 10, 2);
-- Answer: MULTIPOINT((190 300), (10 11 10))
-- Update only non-existant z-values:
SELECT ST_UpdateZ('MULTIPOINT((190 300), (10 11 2))', 10, 3);
-- Answer: MULTIPOINT((190 300 10), (10 11 2))