I have 2 tables
I have a set of Linestrings in the column dijkstra_results_geo.geom_path_intermediaire (defined as geometry(Linestring, 4326)).
I would like to collect all these Linestrings into one big Multilinestring in the column dijkstra_results_geo_aggregate.path (1 row with gid=1).
I tried :
UPDATE dijkstra_results_geo_aggregate SET path = (SELECT St_Union(dijkstra_results_geo.geom_path_intermediaire) FROM dijkstra_results_geo) WHERE gid=1;
The query works but the "path" column (defined as geometry(Multilinestring, 4326)) remains empty.
I also tried to use
St_Collect but it's empty as well.
I finally tried the query with the "path" and "geom_path_intermediaire" columns defined as "geometry", but it's the same.
Could you please help me?