rt_envelope.sql 460 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14
-- NULL raster
SELECT ST_AsText(ST_Envelope(NULL::raster));

-- width and height of zero
SELECT ST_AsText(ST_Envelope(ST_MakeEmptyRaster(0, 0, 0, 0, 1, -1, 0, 0, 0)));

-- width of zero
SELECT ST_AsText(ST_Envelope(ST_MakeEmptyRaster(0, 9, 0, 0, 1, -1, 0, 0, 0)));

-- height of zero
SELECT ST_AsText(ST_Envelope(ST_MakeEmptyRaster(9, 0, 0, 0, 1, -1, 0, 0, 0)));

-- normal raster
SELECT ST_AsText(ST_Envelope(ST_MakeEmptyRaster(9, 9, 0, 0, 1, -1, 0, 0, 0)));