pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedST_Union(rast, uniontype) treat bands with different classes as the same as first band
2+ messages / 2 participants
[nested] [flat]
* ST_Union(rast, uniontype) treat bands with different classes as the same as first band
@ 2023-01-20 13:56 Liang Shen <shenzhuxi@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Liang Shen @ 2023-01-20 13:56 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: ST_Union(rast, uniontype) treat bands with different classes as the same as first band
@ 2023-01-20 14:42 hubert depesz lubaczewski <depesz@depesz.com>
parent: Liang Shen <shenzhuxi@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: hubert depesz lubaczewski @ 2023-01-20 14:42 UTC (permalink / raw)
To: Liang Shen <shenzhuxi@gmail.com>; +Cc: pgsql-bugs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-01-20 14:42 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-01-20 13:56 ST_Union(rast, uniontype) treat bands with different classes as the same as first band Liang Shen <shenzhuxi@gmail.com>
2023-01-20 14:42 ` hubert depesz lubaczewski <depesz@depesz.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox