[postgis-users] Looking for examples of using CTE andrecursivequeries with PostGIS

[Paragon Corporation]

Eric,

Glad you like our book so far. Here is an example we wrote up using
recursive queries.  We don't have it using spatial in this, but will have an
example of it in the book as it applies to PostGIS.

http://www.postgresonline.com/journal/index.php?/archives/138-Allocating-Peo
ple-into-Groups-with-SQL-the-Sequel.html

Thanks,
Leo and Regina



-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Randall,
Eric
Sent: Sunday, October 11, 2009 12:24 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Looking for examples of using CTE
andrecursivequeries with PostGIS

Wow, that's great!  They do such nice work.  I'm reading their
book-in-progress too and it's great. 
Thanks. 

-Eric


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of courtin
olivier
Sent: Sunday, October 11, 2009 11:56 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Looking for examples of using CTE and
recursivequeries with PostGIS



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_postgi
s_spatial_tricks
 >

HTH,

--
Olivier
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users