[postgis-users] error

[Sydney Togarepi]

My sql query is liek this

select cntry_name
from public.country
where st_dwithin(st_transform(country.geom,32736),(select
(st_transform(cities1.geom,32736))from public.cities1 where city_name
='Harare'),600)

and i am getting this error message.
ERROR: ptarray_contains_point called on unclosed ring CONTEXT: SQL function
"st_dwithin" statement 1 SQL state: XX000

i am trying to get cities that are within a distance of 600unit from the
given city


Sydney Togarepi
cell +263 773 883 627
e-mail:stogarepi at gmail.com
Skype: sydney998
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220524/f8451045/attachment.htm>