[postgis-users] Looking for examples of using CTE and recursive queries with PostGIS

[Randall, Eric]

Hey all,

I've recently started using postgis 1.4 and pgsql 8.4 and wondered if anyone could give examples of
using common table expressions and recursive queries in a spatial setting?

Thanks!

-Eric