What is policy of supporting PostgreSQL packages and distributions? At this time it seems to me little random. 9.0 RHEL/CentOS/Scientific Linux 6 - x86 doesn't contain Postgis, while x86_64 contains. Slony1 is placed in both RHEL 6 versions, but only x86 RHEL 5 repository and so on.
With this I'm lobbying for Posgis RPMs for 9.1, which I can't see yet Sorry for impatience.
Paul, I'm trying apdetad your example to find the longest river inside one basin, so, the result it's exactly the inverse that I need (like your solution), I made some unsuccessfully tests using ST_Reverse() in my geometry, So... Can you help me with this solution? here is my fail logic:-- Create a ViewCREATE OR REPLACE VIEW river_inv AS SELECT river.gid, st_reverse(river.the_geom) AS the_geom FROM river;--Using your queryWITH RECURSIVE walk_network(gid, the_geom) AS ( SELECT gid, the_geom FROM river_inv WHERE gid = 212 UNION ALL SELECT n.gid, n.the_geom FROM river n, walk_network w WHERE ST_DWithin(ST_EndPoint(w.the_geom),ST_StartPoint(n.the_geom),0.01) )SELECT *FROM walk_network;Thanks for shared your knowledge.