[postgis-devel] [WKT Raster] Type of extent column ofRASTER_COLUMNS

[Mateusz Loskot]

Frank Warmerdam wrote: 
> Mateusz Loskot wrote:
> > Mateusz Loskot wrote:
> >> Hi,
> >>
> >> I'm wondering why extend column of RASTER_COLUMNS table is of type
> of
> >> GEOMETRY instead of POLYGON (or even BOX2D).
> >
> > I'm taking the idea of BOX2D back, completely forgot it's of POLYGON
> type as well.
> 
> Mateusz,
> 
> I would add that using a polygon has the potential of describing
> irregular image footprints, though this is not supported in the
> "regular_blocking=true" case.

Frank,

Good point.

For now, I've added validation of geometry extent type to accept POLYGONs only
Plus, SRID values of raster and extent are compared.

BTW, I'm a complete noob in the world of PL/PgSQL, so I'd appreciate
if someone fluent in this language could review if the code of AddRasterColumn
function is acceptable/correct/efficient/etc.

Best regards,
--
Mateusz Loskot
Senior Programmer, Cadcorp
http://www.cadcorp.com