> Why do you have 3 columns in the select writing into two in the INSERT?
> Shouldn't it be:
> INSERT INTO spl_road_centre_line(
> gid, the_geom
>)
>SELECT gid, st_transform(the_geom, 4283)
> FROM spl_road_centre_line_mga
> ORDER BY gid ASC;
Simon,
You are correct, I have in error included 3 columns, but even so when I have
run the query with the correct number of columns, I dont seem to have
records that are transformed.
So the query that I have constructed would be the way to transform records
from one coord system to another?
Ben
--
View this message in context:
http://www.nabble.com/Correct-use-of-ST_Transform-tp23380852p23381799.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
