Hi, Error 1 : if you use capital letter for the first letter of the col name you must use double quotes "COLNAME" Error2 : POINT(%s %s) => Postgis is waiting for wkt string and %s %s is the argument given by a string in python : you must remplace it with real example data (i.e. the coordinates you want to use in RGF93) Error3 : see error 2
HTH Hugues. -----Message d'origine----- De : [email protected] [mailto:[email protected]] De la part de dandrigo Envoyé : jeudi 26 juin 2014 11:12 À : [email protected] Objet : [postgis-users] SQL queries ( with st_intersects) : error messages Dear all, Following to my last posts, i tried to execute 3 sql queries via pgadmin. But i have an error message for each query. Below, i put usefull screenshots representing the interface of pgadmin query : SS_pg_query1.JPG <http://postgis.17.x6.nabble.com/file/n5006542/SS_pg_query1.JPG> SS_pg_query2.JPG <http://postgis.17.x6.nabble.com/file/n5006542/SS_pg_query2.JPG> SS_pg_query3.JPG <http://postgis.17.x6.nabble.com/file/n5006542/SS_pg_query3.JPG> Could you throw light for me? Regards. -- View this message in context: http://postgis.17.x6.nabble.com/SQL-queries-with-st-intersects-error-messages-tp5006542.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
