[postgis-users] Correct use of ST_Transform

[benton101]

> 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.