From f316ee22824ba33b325ad2260f3160602ce60328 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Wed, 23 May 2012 06:58:51 +0000 Subject: [PATCH] force casting to text for band types in various examples prevent unknown warnings (alibo noted) git-svn-id: http://svn.osgeo.org/postgis/trunk@9805 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/reference_raster.xml | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/doc/reference_raster.xml b/doc/reference_raster.xml index 51320cff2..892f14e2c 100644 --- a/doc/reference_raster.xml +++ b/doc/reference_raster.xml @@ -415,7 +415,7 @@ VALUES (1, CREATE TABLE myrasters(rid SERIAL primary key, rast raster); INSERT INTO myrasters(rast) -SELECT ST_AddBand(ST_MakeEmptyRaster(1000, 1000, 0.3, -0.3, 2, 2, 0, 0,4326), 1, '8BSI', -129, NULL); +SELECT ST_AddBand(ST_MakeEmptyRaster(1000, 1000, 0.3, -0.3, 2, 2, 0, 0,4326), 1, '8BSI'::text, -129, NULL); SELECT AddRasterConstraints('myrasters'::name, 'rast'::name); @@ -436,7 +436,7 @@ SELECT srid, scale_x, scale_y, blocksize_x, blocksize_y, num_bands, pixel_types, CREATE TABLE public.myrasters2(rid SERIAL primary key, rast raster); INSERT INTO myrasters2(rast) -SELECT ST_AddBand(ST_MakeEmptyRaster(1000, 1000, 0.3, -0.3, 2, 2, 0, 0,4326), 1, '8BSI', -129, NULL); +SELECT ST_AddBand(ST_MakeEmptyRaster(1000, 1000, 0.3, -0.3, 2, 2, 0, 0,4326), 1, '8BSI'::text, -129, NULL); SELECT AddRasterConstraints('public'::name, 'myrasters2'::name, 'rast'::name,'regular_blocking', 'blocksize'); -- get notice-- @@ -944,13 +944,13 @@ WHERE short_name = 'GTiff') As g; -- Add another band of type 8 bit unsigned integer with pixels initialized to 200 UPDATE dummy_rast - SET rast = ST_AddBand(rast,'8BUI',200) + SET rast = ST_AddBand(rast,'8BUI'::text,200) WHERE rid = 1; -- Create an empty raster 100x100 units, with upper left right at 0, add 2 bands (band 1 is 0/1 boolean bit switch, band2 allows values 0-15) INSERT INTO dummy_rast(rid,rast) - VALUES(10, ST_AddBand(ST_AddBand(ST_MakeEmptyRaster(100, 100, 0, 0, 1, -1, 0, 0, 0), '1BB'), '4BUI') ); + VALUES(10, ST_AddBand(ST_AddBand(ST_MakeEmptyRaster(100, 100, 0, 0, 1, -1, 0, 0, 0), '1BB'::text), '4BUI'::text) ); -- output meta data of raster bands to verify all is right -- SELECT (bmd).* -- 2.40.0