From 1ca56d24e192ee64dac1ce7f7798120c7e72d374 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Sat, 10 Dec 2011 18:03:02 +0000 Subject: [PATCH] fix error in logic git-svn-id: http://svn.osgeo.org/postgis/trunk@8348 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/reference_raster.xml | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/doc/reference_raster.xml b/doc/reference_raster.xml index af3ba9daf..492d3df84 100644 --- a/doc/reference_raster.xml +++ b/doc/reference_raster.xml @@ -1156,14 +1156,14 @@ FROM (SELECT ST_MetaData(rast) As rmd Examples: Multi-Band versions -- Aggregate the 1st band of a table of like rasters into a single raster --- with as many bands as there are test_types and as many rows as there are time_slots +-- with as many bands as there are test_types and as many rows (new rasters) as there are mice -- NOTE: The ORDER BY test_type is only supported in PostgreSQL 9.0 -- for 8.4 and below it usually works to order your data in a subselect (but not guaranteed) -- The resulting raster will have a band for each test_type alphabetical by test_type -- For mouse lovers: No mice were harmed in this exercise -SELECT rabbit, ST_AddBand(NULL, array_agg(rast ORDER BY test_type), 1 ) As rast +SELECT mouse, ST_AddBand(NULL, array_agg(rast ORDER BY test_type), 1 ) As rast FROM mice_studies - GROUP BY mice; + GROUP BY mouse; -- 2.40.0