Syntax: CASE WHEN - THEN - ELSE - END

Beispiel:

SELECT ST_Area( ST_Intersection
(
:POLYGON, 
CASE WHEN GeometryType( geography ) = 'POLYGON' THEN geography ELSE geography_polygon END
 )) as intersection
FROM discovery