Tom Lane kirjutas K, 04.02.2004 kell 06:04: > Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > > Wasn't there some guy at RedHat doing it? > > Andrew Overholt did some work on SQL99 recursive queries, but went back > to university without having gotten to the point where it actually > worked. One of the many things on my to-do list is to pick up and > finish Andrew's work on this. If someone has time to work on it, > let me know and I'll try to get what he had over to you.
I attach my early attempts at doing the same. I also sent this to Andrew while he was working on it, and he claimed that his version was similar. I think he sent me a slightly more advanced verion of this, but I'm currently unable to lovcate it. This has mainly the syntax part (without recursion control IIRC) and some initial documentation (in python's StructuredText and html formats) If I find Andrews variant I'll try to post it too. ------------- Hannu
pg-with-recursive.tar.gz
Description: application/compressed-tar
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
