[postgis-devel] Empty for Discussion

Martin Davis mtnclimb at gmail.com
Fri Feb 10 12:02:19 PST 2023


So seems to me that

ST_NumGeometries('GEOMETRYCOLLECTION(POINT EMPTY, POINT EMPTY)'::geometry)
==> 0

is inconsistent with

ST_GeometryN('GEOMETRYCOLLECTION(POINT EMPTY, POINT EMPTY)'::geometry, 1)
==> POINT EMPTY

I think ST_NumGeometries('GEOMETRYCOLLECTION(POINT EMPTY, POINT
EMPTY)'::geometry) should return 2.

On Fri, Feb 10, 2023 at 11:39 AM Paul Ramsey <pramsey at cleverelephant.ca>
wrote:

> select st_astext('GEOMETRYCOLLECTION(POINT EMPTY, POINT EMPTY)'::geometry);
> select st_isempty('GEOMETRYCOLLECTION(POINT EMPTY, POINT
> EMPTY)'::geometry);
> select st_numgeometries('GEOMETRYCOLLECTION(POINT EMPTY, POINT
> EMPTY)'::geometry); st_numgeometries
> select st_astext(st_geometryn('GEOMETRYCOLLECTION(POINT EMPTY, POINT
> EMPTY)'::geometry, 1));
>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20230210/1971fdfe/attachment.htm>


More information about the postgis-devel mailing list