<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div>Hi,</div><div><br></div>I’m very new to PostGIS and I’m running into a seemingly strange situation.<div><br></div><div>I have a table of geography points, and I am trying to select rows where the point is <font face="Menlo">NOT IN</font> a given list:</div><div><br></div><div> <font face="Menlo">SELECT "address_coordinates".* FROM "address_coordinates" WHERE "address_coordinates"."address_id" = 2269 AND (lonlat NOT IN ('POINT(-100.768049 46.784703)’))</font></div><div><br></div><div>However, this returns rows where the the lonlat column IS the same point because I get the same result row when I run the query with the <font face="Menlo">NOT</font> removed:</div><div><br></div><div> <font face="Menlo">SELECT "address_coordinates".* FROM "address_coordinates" WHERE "address_coordinates"."address_id" = 2269 AND (lonlat IN ('POINT(-100.768049 46.784703)’))</font></div><div><br></div><div><br></div><div><br></div><div>I can get the expected results if I move the <font face="Menlo">NOT</font> to before the column name:</div><div><br></div><div> <font face="Menlo">SELECT "address_coordinates".* FROM "address_coordinates" WHERE "address_coordinates"."address_id" = 2269 AND NOT (lonlat IN ('POINT(-100.768049 46.784703)’))</font></div><div><br></div><div><br></div><div>Any idea what is causing this?</div><div><br></div><div>Caleb</div></body></html>