Re: [postgis-users] st_clusterwithin on postgis 2

Hi Birgit, thank you very much for your reply. I'm going to test your code asap and let you know about it. Regards, Paolo 2016-09-22 9:47 GMT+02:00 Birgit Laggner : > Hi Paolo, > > sorry, I did not really think it through, but now the changed and tested > example: > >

Re: [postgis-users] st_clusterwithin on postgis 2

Hi Paolo, sorry, I did not really think it through, but now the changed and tested example: DO $$ DECLARE distance numeric; t_schema varchar; input_table varchar; output_table varchar; r record; gid integer; geom geometry; c record; c_gid integer[]; c_geom geometry[]; i record; BEGIN

Re: [postgis-users] st_clusterwithin on postgis 2

Hi Paolo, here an example how it could work (mind that you have to replace the ??). You could also recode the DO block into a function if you would like that better. DO $$ DECLARE distance numeric; t_schema varchar; input_table varchar; output_table varchar; r record; gid integer; geom

[postgis-users] st_clusterwithin on postgis 2

Hi all, I need to run a query on my postgres/postgis (9.3/2.0) that uses ST_CLUSTERWITHIN function. This function is available since postgis 2.2.0 so I should do a soft upgrade on my ubuntu server. Since we have a kind of customer demo in a few days and have no much time left, I am not willing