[postgis-users] Area calculation oh two polygon that they are overlapping

[olivier.amram at free.fr]

Hi,

I'd like to compute the total area of polygon that intersects with another
polygon

Polygon(0 0,0 3,3 3,3 0,0 0)
Polygon(1 1,4 1,4 4,1 4,1 1)

The total area is 14 but I don't find a solution to compute this value.

e.g. SELECT Area(GeomFromText('MultiPolygon( ((0 0,0 3,3 3,3 0,0 0)),((1 1,1 4,4
4,4 1,1 1)))')) --> 18

Have you any idea ?

Thank,

Olivier.