[postgis-users] Change projection in select?

[Rodrigo Martín LÓPEZ GREGORIO]

Hi Magnus

Try this:

*SELECT AsText(Transform(geom,3021)) from myTable;*

Rodrigo.

On Dec 13, 2007 1:22 PM, Runesson Magnus <Magnus.Runesson at smhi.se> wrote:

> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071213/113c8ede/attachment.html>