[postgis-users] ST_GeomFromText function doubt

Hello users this is my first post i have a dout using this function, i'm newbie in postgis and try to underestand the spatial relation function. im using the follwing query SELECT name, the_geom, ST_AsText(the_geom),ST_GeomFromText(ST_AsText(the_geom)) FROM nyc_subway_stations WHERE name = 'Broad

Re: [postgis-users] ST_GeomFromText function doubt

Try this: SELECT name, the_geom, ST_AsText(the_geom),ST_GeomFromText(ST_AsText(the_geom),ST_SRID(the_geom)) FROM nyc_subway_stations WHERE name = 'Broad St'; The trouble is that ST_AsText drops the SRID information, so when you convert that back into a binary geometry, it has a different