From: hubert depesz lubaczewski <depesz@depesz.com>
To: Liang Shen <shenzhuxi@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: ST_Union(rast, uniontype) treat bands with different classes as the same as first band
Date: Fri, 20 Jan 2023 15:42:10 +0100
Message-ID: <Y8qoQiK3Hi3ZGOzq@depesz.com> (raw)
In-Reply-To: <CANTi=nbwzQ4RP0nB2Rzr0CxAj=WtMLXSzOsTRyuh5dHe2EHbGA@mail.gmail.com>
References: <CANTi=nbwzQ4RP0nB2Rzr0CxAj=WtMLXSzOsTRyuh5dHe2EHbGA@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: depesz@depesz.com, shenzhuxi@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: ST_Union(rast, uniontype) treat bands with different classes as the same as first band
In-Reply-To: <Y8qoQiK3Hi3ZGOzq@depesz.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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