Re: ST_Union(rast, uniontype) treat bands with different classes as the same as first band - Mailing list pgsql-bugs

On Fri, Jan 20, 2023 at 01:56:51PM +0000, Liang Shen wrote:
> Related to https://trac.osgeo.org/postgis/ticket/2200 support multiple
> bands issue
> 
> If the $RASTER has bands like ARRAY['8BUI', '16BUI'], the result of
> ```
>             ST_Union(
>               $RASTER,
>               ARRAY[
>                 ROW(1, 'SUM'),
>                 ROW(2, 'MAX')
>               ]::unionarg[]
>             )
> ```
> will be like ARRAY['8BUI', ' 8BUI'].
> 
> ST_Union always uses the first band class to process the 2nd band and
> ignore the original class.

You might want to report this bug to postgis devs, as it's clearly not
postgresql bug.

Their page (https://postgis.net/support/) lists
https://trac.osgeo.org/postgis as their bug tracker.

depesz