Fork me on GitHub

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))
See also