Timeline for Using ST_Transform when inserting new row?
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 18, 2019 at 20:43 | history | edited | PolyGeo♦ | CC BY-SA 4.0 |
deleted 8 characters in body; edited title
|
| Jan 27, 2015 at 9:29 | vote | accept | user1919 | ||
| Jan 23, 2015 at 11:35 | answer | added | user1919 | timeline score: 2 | |
| Jan 22, 2015 at 11:58 | comment | added | John Powell | Oh, yes, forgot the comma, sorry. | |
| Jan 22, 2015 at 11:58 | comment | added | user1919 | Thanks for your answer. I followed your suggestion and with some small modification in worked.INSERT INTO imgRural(geom) VALUES (ST_Transform(ST_GeomFromText('POINT(23.771111111111 38.013888888889)',4326),2100)) RETURNING imgId; | |
| Jan 22, 2015 at 11:55 | comment | added | John Powell | You need to set the SRID to 4326 before you can transform it. Something like, INSERT INTO imgRural(geom) VALUES (ST_Transform(ST_GeomFromText('POINT(23.771111111111 38.013888888889)', 4326), 2100)) RETURNING imgId; | |
| Jan 22, 2015 at 11:52 | history | asked | user1919 | CC BY-SA 3.0 |