Alternative ST_NumGeometries in type geography

Question

In PostGIS (2.1.8) I use function ST_NumGeometries for nums of count geometry. This function have one argument 'geometry' type. I need this function for geography type. I looked for but I didn't find it.

Answer 1

From the docs

ST_NumGeometries — If geometry is a GEOMETRYCOLLECTION (or MULTI*) return the number of geometries, for single geometries will return 1, otherwise return NULL.

So, as mentioned in the comments, simply cast first with ::geometry

SELECT ST_NumGeometries( geog::geometry )
FROM CAST( ST_Multi(ST_MakePoint(1,1)) AS geography) AS geog;

SELECT ST_NumGeometries( geog::geometry )
FROM CAST( ST_ForceCollection(ST_MakePoint(1,1)) AS geography) AS geog;