[postgis-users] ST_X does not exist in an update statement

[Denis Rouzaud]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170718/d2f9af4f/attachment.html>