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 structure than the binary structure that includes the SRID. P. On Wed, Oct 27, 2010 at 2:29 PM, Paul Alarcon <[email protected]> wrote: > 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 St'; > but the_geom field is not the same as te ST_geomfrom text field, what is > wrong ? > Thanks a lot > greetings Paul > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
