[postgis-users] Usage of Transform() function in a query.

[David.Jacques at CCRS.NRCan.gc.ca]

I need to reproject a spatial table from one SRID to another
Both the source and destination SRIDs are in the SPATIAL_REF_SYS table.
I've consulted the manual and the following is presented...

SELECT transform(GEOM,4269) FROM GEOTABLE

Here is the exact query

SELECT transform(the_geom,42304) FROM xxmodishotspots;

What I get is all records consisting of 1 column called "transform" with all
null values.

I expected to get the same output as SELECT * from xxmodishotspots; would
produce, with
 the exception being that "the_geom" column would contain a value like

	SRID=42304;POINT(-552256.351008368 22239.2415119158)

	instead of

	SRID=4269;POINT(-90.673 69.4310000006199)


Does anyone have a better example than the manual ? I can't see what I am
doing wrong.


Thanks in advance..