Dissolve keeping all attributes values (concatenation/aggregation)?

[Erik Wienhold]

On 2025-09-30 17:29 +0200, celati Laurent wrote:
> But when i rerun the query with the edit (adding the closing parenthesis) :
> 
> *SELECT     min(union_v4.max_hierar) as id,     array_agg(union_v4.id)
>  as ids,     union_v6.geomFROM union_v4,    (SELECT
>       (ST_Dump(St_multi(ST_Union(geom)))).geom as geom    FROM
> union_v6)WHERE     st_intersects(union_v4.geom, union_v6.geom)GROUP BY
> union_v6.geom*
> 
> *I obtain this time the message : * ERROR: la relation « union_v4 »
> n'existe pas LINE 5: FROM union_v4, ^ ERREUR: la relation « union_v4 »
> n'existe pas SQL state: 42P01 Character: 105
> 
> However, i have one table called "union_v4" within my postgis db.
> thanks so much.

* In which schema is union_v4 defined?

* What is your current search_path setting?  Check SHOW search_path;

-- 
Erik Wienhold