<html>
<head>
</head>
<body>This is really cool Regina and Leo<br />
<br />
It's a new way of thinking for me to to use this recursive thing, but I can see that it is very useful.<br />
I hope I will get some time in the near future to try to understand it better.<br />
<br />
Also the windowing functions together with postgis aggregate function will be fun to try.<br />
<br />
/Nicklas<br />
<br />
<br />
<br />
<br />
<br />
2009-07-17 Paragon Corporation wrote:<br />
<br />
Nicklas,<br />
><br />
>We tried CTEs against that annoying issue of functions not being cached in<br />
>the same row. Preliminary tests seem to suggest it might be the ideal<br />
>solution for this.<br />
>We suspect it will also be good in many other scenarios where the planner<br />
>refuses to use indexes in the right order etc.<br />
><br />
>http://www.postgresonline.com/journal/index.php?/archives/127-guid.html<br />
><br />
>We are going to test with real spatial queries next in preparation for our<br />
>OSCON presentation next week.<br />
><br />
>http://en.oreilly.com/oscon2009/public/schedule/detail/7859<br />
>Sadly it looks like we probably won't have 1.4 out in time for our<br />
>presentation - oh well :(<br />
><br />
><br />
>Anyrate take a look and test with your data to see if it speeds up your<br />
>queries.<br />
><br />
>L & R<br />
><br />
><br />
>_______________________________________________<br />
>postgis-devel mailing list<br />
>postgis-devel@postgis.refractions.net<br />
>http://postgis.refractions.net/mailman/listinfo/postgis-devel<br />
><br />
>
</body>
</html>