79152531

Date: 2024-11-03 10:55:05
Score: 1
Natty:
Report link

Make sure that point_4326 is a POINT type with SRID 4326 defined in the table, as different SRID values might interpret the coordinates differently. Your code is for SRID 4326 so if you have anything else selected for point_4326 select SRID 4326. Since you named your POINT 'point_4326' you probably did select it but check it twice.

If everything is as I told you then try running your query but switch Lng and Lat. If it doesn't show error do SELECT query to see row id 4601 and check if Lng and Lat values are correctly inputed. If yes-reply to this, we'll figure it out then.

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: Shox