Hi all, I'm bumbing my head against the wall.
I have an error "function st_x(geometry) does not exist" in an update statement which I don't understand. If I copy the same exact line in a select statement I get no error... Here is the update statement: update qwat_od.network_element set label_1_x = ST_X(ST_GeomFromEWKB(ST_Fineltra(ST_SetSRID(ST_MakePoint(label_1_x,label_1_y),21781), 'chenyx06.chenyx06_triangles', 'the_geom_lv03', 'the_geom_lv95'))) where label_1_x is not null; and the select statement: select ST_X(ST_GeomFromEWKB(ST_Fineltra(ST_SetSRID(ST_MakePoint(label_1_x,label_1_y),21781), 'chenyx06.chenyx06_triangles', 'the_geom_lv03', 'the_geom_lv95'))) from qwat_od.network_element where label_1_x is not null; How come that the select succees while not the update??? Thanks a lot, Denis
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
