This is a discussion on Re: SQL99 Hierarchical queries within the pgsql Hackers forums, part of the PostgreSQL category; --> Hi Evgen, I just keep pinging this patch thread every once in a while to make sure it doesn't ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi Evgen, I just keep pinging this patch thread every once in a while to make sure it doesn't get forgotten How is the syncing with 8.1 CVS coming along? Chris Evgen Potemkin wrote: > Hi hackers! > > I have done initial implementation of SQL99 WITH clause (attached). > It's now only for v7.3.4 and haven't a lot of checks and restrictions. > It can execute only simple WITH queries like > WITH tree AS (SELECT id,pnt,name,1::int AS level FROM t WHERE id=0 > UNION SELECT t.id,t.pnt,t.name,tree.level+1 FROM t JOIN tree ON > tree.id=t.pnt ) SELECT * FROM tree; > It would be great if someone with knowledge of Pg internals can make a > kind of code review and make some advices how to better implement all > this. > > Regards, Evgen. > > > ------------------------------------------------------------------------ > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly |