Counting Things

[Paul Ramsey]

I guess it makes more sense with added context.

pramsey=# select st_numgeometries('MULTIPOINT EMPTY');
 st_numgeometries
------------------
                0
(1 row)

pramsey=# select st_numgeometries('POINT EMPTY');
 st_numgeometries
------------------
                0
(1 row)

pramsey=# select st_numgeometries('POINT (1 1)');
 st_numgeometries
------------------
                1
(1 row)

On Thu, Feb 15, 2024 at 3:14 PM Paul Ramsey <pramsey at cleverelephant.ca> wrote:
>
> Since we are counting things, this seemed a little suspicious to me:
>
> pramsey=# select ST_NumGeometries('POINT(0 0)');
>  st_numgeometries
> ------------------
>                 1
> (1 row)
>
> pramsey=# select st_numgeometries('POINT EMPTY');
>  st_numgeometries
> ------------------
>                 0
> (1 row)
>
> Hmmmmmm,
>
> P