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

[courtin olivier]

On Oct 11, 2009, at 5:46 PM, Randall, Eric wrote:

Hi,

> 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?

Regina & Leo wrote this for Oscon, with some CTE examples:
<http://www.bostongis.com/PrinterFriendly.aspx?content_name=oscon2009_postgis_spatial_tricks 
 >

HTH,

--
Olivier