Skip to content

ST_AREA result mismatch with PostGIS 3.2.1 #50

@marklit

Description

@marklit

I assume both of these should be doubles and should match. This was run on Ubuntu 20 LTS with PostgreSQL 15.

select ST_AREA(ST_GEOMFROMTEXT('POLYGON ((-82.03623 29.60482, -82.0357 29.605, -82.03526 29.60513, -82.03623 29.60482))')) test
┌───────────────────────┐
│         test          │
│        double         │
├───────────────────────┤
│ 5.150013748789206e-09 │
└───────────────────────┘
SELECT ST_AREA('SRID=4326;POLYGON ((-82.03623 29.60482, -82.0357 29.605, -82.03526 29.60513, -82.03623 29.60482))');
        st_area
------------------------
 5.1500000016351076e-09
SELECT pg_typeof(ST_AREA('SRID=4326;POLYGON ((-82.03623 29.60482, -82.0357 29.605, -82.03526 29.60513, -82.03623 29.60482))'));
    pg_typeof
------------------
 double precision

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions