SQL99 Hierarchical queries - Mailing list pgsql-hackers

From Evgen Potemkin
Subject SQL99 Hierarchical queries
Date
Msg-id 44458e32050224020236ac358f@mail.gmail.com
Whole thread Raw
Responses Re: SQL99 Hierarchical queries  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Re: SQL99 Hierarchical queries  (Pavel Stehule <stehule@kix.fsv.cvut.cz>)
Re: SQL99 Hierarchical queries  (Mike Benoit <ipso@snappymail.ca>)
Re: SQL99 Hierarchical queries  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
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.

Attachment

pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Finding if old transactions are running...
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: SQL99 Hierarchical queries