[Qgis-user] How to load postgis layer without gid (if possible..)?

[Pietro Rossin]

@Anna123
**************
so something like:
select row_number() over(order by geom)::integer as no,
ST_Union(ST_Buffer(geom,500) ) as geom from public.mytable group by geom;

should also work.
****************
yes, this work, but I loose the union process and I get a buffer for each
feature in mytable

@Bernhard
*************
SELECT min(my_pk_column), ST_Union(ST_Buffer(geom,500)) as geom FROM
public.mytable;
**************
Super, It work.

Thankyou all
Pietro




--
View this message in context: http://osgeo-org.1560.n6.nabble.com/How-to-load-postgis-layer-without-gid-if-possible-tp5014459p5014508.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20121107/8262b5b7/attachment.html>