Hi All, I'm creating a PLPGSQL which has 2 parameters: a geometry and a table name.
The query is something like UPDATE table_name SET FIELD=geometry. I've tried to use EXECUTE like this EXECUTE 'UPDATE '||quote_ident(table_name)||' SET FIELD='||geometry::geometry but I'm getting an error in the geometry: (HINT: Could not choose a best candidate operator. You might need to add explicit type casts.) any ideas ? -- Sebastian E. Ovide
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
