SELECT AsText(ST_Transform(geom, 3021)) FROM mytable If you are using a pre-1.2 install of PostGIS you may need to use transform(geom,3021) instead of st_transform(geom,3021)
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Runesson Magnus Sent: Thursday, December 13, 2007 8:22 AM To: [email protected] Subject: [postgis-users] Change projection in select? I have a table where my geometries are saved in SRID 4326. To get my result in text I do: SELECT asText(geom) FROM myTable; Sometimes I want to get my results from the select in 3021 instead. Can I do that? How do I do that? Regards, /Magnus, SMHI _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
