[postgis-users] Issue with ST_WITHIN

[Arnaud L.]

Le 06/08/2019 à 06:36, Michael Lubinsky a écrit :
> I was thinking what the reason for the error is: the ST_WITHIN arguments 
> types should be GEOMETRY, but I am passing the POLYGONs.


Yes, because POLYGON is a *PostgreSQL* geometric data type while 
GEOMETRY is a *PostGIS* data type.
PostGIS functions only work on PostGIS data types, so you'll have to 
create your columns as Geometry(Polygon).

Cheers
--
Arnaud