[Qgis-user] qgis/postgis : flow map

[image]

So, i succeed in executing the query without error message. The query
generates a temp postgis layer linear. 
I attach the SS below showing the qgis canvas

<http://osgeo-org.1560.x6.nabble.com/file/t365144/6.jpg> 

But i have always a problem regarding the GROUP BY...i would like to do a
GROUP BY one field only...but i can't generate the query without put all
fields present in SELECT into GROUP BY !

Please read my currently query : 

create table temp as select
st_makeline(st_makepoint(entrants_v2.x_resi,entrants_v2.y_resi),st_makepoint(entrants_v2.x_tr,entrants_v2.y_tr))as
geometry,sum(entrants_v2.ipondi) as sumipondi, entrants_v2.codgeo_res as
codgeo_res, entrants_v2.codgeo_tr as codgeo_tr

from entrants_v2
group by
entrants_v2.codgeo_res,entrants_v2.x_resi,entrants_v2.y_resi,entrants_v2.x_tr,entrants_v2.y_tr,entrants_v2.ipondi,entrants_v2.codgeo_tr

Is it a way to assign one field into group by with postgis? Because my
result is false. 
In advance, thank you very much. 



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html