[postgis-users] Merging lines - one on another

[Matej Mailing]

Thanks to both of you.

Now I have a query like:

SELECT *
FROM public.my_table AS part_1, public.my_table AS part_2
WHERE ST_SharedPaths(part_2.wkb_geometry_4326,
ST_SnapToGrid(part_1.wkb_geometry_4326, part_2.wkb_geometry_4326, 0.5,
0, 0, 0))

- it seems that ST_Snap(geom, geom, float) doesn't exist at my PostGIS
- is it correctly that I have changed it to ST_SnapToGrid, which also
requires more float parameters?
- it seems also that ST_SharedPath doesn't exist. Did you mean ST_SharedPaths?

When I run this query, I get an error:
ERROR:  function st_sharedpaths(geometry, geometry) does not exist
LINE 3: WHERE ST_SharedPaths(part_2.wkb_geometry_4326, ST_SnapToGrid...
              ^
HINT:  No function matches the given name and argument types. You
might need to add explicit type casts.

Do I need some other PostGIS version or am I doing it wrong?

TIA,
Matej

2012/1/21 Sandro Santilli <strk at keybit.net>:
> On Sat, Jan 21, 2012 at 02:19:06PM +0100, Andrea Peri wrote:
>
>> ST_SharedPath(geom1, ST_Snap(geom1, geom2, 0.5))
>
> I guess you meant:
>
>  ST_SharedPath(geom2, ST_Snap(geom1, geom2, 0.5))
>
> --strk;
>
>  ()   Free GIS & Flash consultant/developer
>  /\   http://strk.keybit.net/services.html
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users