ST_Union(rast, uniontype) treat bands with different classes as the same as first band

From: Liang Shen <shenzhuxi(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: ST_Union(rast, uniontype) treat bands with different classes as the same as first band
Date: 2023-01-20 13:56:51
Message-ID: CANTi=nbwzQ4RP0nB2Rzr0CxAj=WtMLXSzOsTRyuh5dHe2EHbGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message hubert depesz lubaczewski 2023-01-20 14:42:10 Re: ST_Union(rast, uniontype) treat bands with different classes as the same as first band
Previous Message PG Bug reporting form 2023-01-20 13:41:07 BUG #17756: Invalid replica indentity set order in a dump