[postgis-users] Change projection in select?

[Runesson Magnus]

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