[postgis-devel] Empty for Discussion

[Martin Davis]

Note my result for ST_GeometryN is on PostGIS 3.1.4.  More recent versions
might be different (i.e. returning NULL)?

On Fri, Feb 10, 2023 at 12:02 PM Martin Davis <mtnclimb at gmail.com> wrote:

> 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/86f18535/attachment.htm>