I'm curious what kind of performance differences there would be over using something like the nested-set model?
Would this be faster, or slower? On Thu, 2005-02-24 at 13:02 +0300, 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 [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly -- Mike Benoit <[EMAIL PROTECTED]>
signature.asc
Description: This is a digitally signed message part
