Hi, list,
I'm trying to get the fid (integer) of objects in table line where the geometry (postgis) is inside another geometry from another table (polygon),
But I would not like to get the objects with the highest fid inside the polygons of table buffered.
I've tried this:
SELECT fid FROM
"line" USING "polugon" AS b WHERE
ST_Contains(b.geom, "line".geom) AND "line".fid NOT IN (SELECT MAX("line".fid)
);
It complains about "USING" in line 2.
Anyone who knows how I should do it instead?
Kind regards,
Paul