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: [email protected] [mailto:[email protected]] 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: [email protected] [mailto:[email protected]]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 [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
