[postgis-users] How can i interchange(swap) the values of a band in postgis raster

[Pierre Racine]

> but if ST_Band(rast,2,1) means that i am assigning the value of 2nd raster band
> to 1st......will it create a new raster with this.......i tried this ...but i m not sure
> whether it creates new raster or it replaces values in same raster.

Most function create a new raster. If you want to "save" your raster back to the table you have to write an "UPDATE" SQL statement.

Pierre