<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: arial,helvetica,sans-serif; font-size: 10pt; color: #000000'>Good evening, <br><br>I would like to apply what I red from Pierre Racine about the way to add a band to a raster from another one.<br>http://geospatialelucubrations.blogspot.fr/2012/09/loading-many-rasters-into-separate.html?showComment=1346973298820#c4654958992264542142<br><br>I have 3 tables all tiled the same way.<br>The first one "altitude", the second one "temp_min" and the third one "temp_max" <br><br>In order to facilitate analyses, I would like to add 2 bands to the raster "altitude"<br><br>I translate what I understood from Mr Racine like this, could someone tell me if I am wrong ?<br><br>UPDATE altitude SET rast=ST_AddBand(altitude.rast, min.rast)<br>FROM temperature_min min<br>WHERE ST_UpperLeftX(min.rast) = ST_UpperLeftX(altitude.rast) <br>AND ST_UpperLeftY(min.rast) = ST_UpperLeftY(altitude.rast);<br><br>UPDATE altitude SET rast=ST_AddBand(altitude.rast, max.rast)<br>FROM temperature_max max<br>WHERE ST_UpperLeftX(max.rast) = ST_UpperLeftX(altitude.rast) <br>AND ST_UpperLeftY(max.rast) = ST_UpperLeftY(altitude.rast);<br><br>Thanks a lot!<br><br>Mathieu Bossaert<br><div><span name="x"></span>--<br><font style="color: rgb(102, 102, 102);" size="1"><em>Mathieu BOSSAERT</em><br style="font-style: italic;"><span style="font-style: italic;">Responsable du </span><a style="font-style: italic;" href="http://si.cenlr.org/">système d'information</a></font><font style="font-weight: bold; font-style: italic; color: rgb(102, 102, 102);" size="1"> du CEN L-R</font><br><font style="font-style: italic; color: rgb(102, 102, 102);" size="1">04 67 29 90 65 - sig@cenlr.org</font><br><img src="http://sig.cenlr.org/_media/signature-courriel_mathieu.jpg"><br><span name="x"></span></div><hr id="zwchr"></div></body></html>