[postgis-users] Help with ST_Within query issue...

[Paul Ramsey]

The error on pg10 is interesting and worrying, but at a first approximation your pg14 problem is that you have reversed the coordinate order in your polygon. The order should be longitude/latitude and yours is latitude/longitude.

Try

ST_GeomFromText('POLYGON((-119.53618 34.67010 ,
 -116.02055 34.67010 ,
 -116.02055 32.72798,
 -119.53618 32.72798 ,
 -119.53618 34.67010))', 4326)

P.

> On Jan 11, 2023, at 8:31 AM, Jeffrey Peacock <jeffp.actual at gmail.com> wrote:
> 
> POLYGON((34.67010 -119.53618,