[postgis-users] insert polygon in multipolygon field

[David Blasby]

David TECHER wrote:

>>I want to insert a polygon (returned by
>>enveloppe(geomunion(the_geom))) into
>>a multipolygon column.  How to cast the polygon to a
>>multipolygon ?

If you have a very recent version of postgis, you can use the multi() 
function.  It convert single-type to multi-types.  Ie. 
POLYGON->MULTIPOLYGON.

  select multi('POINT(0 0)'::geometry);

    MULTIPOINT(0 0)


dave