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 <pag66...@gmail.com> 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 > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users