[postgis-users] SQL queries ( with st_intersects) : error messages

[Hugues François]

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 : postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-bounces at lists.osgeo.org] De la part de dandrigo
Envoyé : jeudi 26 juin 2014 11:12
À : postgis-users at lists.osgeo.org
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
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users