Hi,
The issue is indeed you are using Postgres polygons instead of PostGIS
polygons. ST_MakePoint (note ST_ prefix) builds a postgis point.
Non-working countertpart would be this:
SELECT ST_WITHIN('(1,1)'::point, '(1,1)'::point ) ;
On Tue, Aug 6, 2019 at 7:37 AM Michael Lubinsky <mlubin...@hotmail.com>
wrote:
> Environment: PostgreSQL 11.4 with PostGIS 2.5.2
>
> CREATE TABLE m_polygon (id SERIAL PRIMARY KEY, bounds POLYGON);
> INSERT INTO m_polygon(bounds) VALUES(
> '(0.0, 0.0), (0.0, 10.0), (10.0, 0.0), (10.0, 10.0), (0,0)'
> );
>
> SELECT ST_WITHIN(m_polygon.bounds , m_polygon.bounds ) FROM m_polygon;
>
> I am getting the error message for SELECT statement above:
>
> ERROR: function st_within(polygon, polygon) does not exist
> HINT: No function matches the given name and argument types. You might
> need to add explicit type casts
>
> I was thinking what the reason for the error is: the ST_WITHIN arguments
> types should be GEOMETRY, but I am passing the POLYGONs.
>
> However the following works:
>
> SELECT ST_WITHIN(ST_MakePoint(1,1), ST_MakePoint(1,1) ) ;
>
> Thanks!
> Michael
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
--
Darafei Praliaskouski
Support me: http://patreon.com/komzpa
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
