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

2017-07-18 Thread Denis Rouzaud
Hi Giuseppe, Thanks a lot for your reply. Using lower case st_x was ok ST_X was not working in the update statement. That sounds quite weird to me. Thanks a lot for the explanation, it does bring explanation! Cheers, Denis Le mar. 18 juil. 2017 à 15:53, Giuseppe Broccolo a écrit : > Hi De

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

2017-07-18 Thread Giuseppe Broccolo
Hi Denis, 2017-07-18 11:51 GMT+02:00 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... > > Her

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

2017-07-18 Thread 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