From: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
---|---|
To: | pgsql-patches(at)postgresql(dot)org |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | WITH RECURSIVE patches 0803 |
Date: | 2008-08-03 02:47:11 |
Message-ID: | 20080803.114711.73374027.t-ishii@sraoss.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Hi,
Included are the latest WITH RECURSIVE patches against CVS HEAD.
The main differences from previous patches include:
- Allow multiple query names (mutual recursion is not still allowed)
These are some examples from the regression test:
WITH RECURSIVE
x(id) AS (SELECT * FROM y UNION ALL SELECT id+1 FROM x WHERE id < 5),
y(id) AS (values (1))
SELECT * FROM x;
WITH RECURSIVE
x(id) AS
(SELECT 1 UNION ALL SELECT id+1 FROM x WHERE id < 3 ),
y(id) AS
(SELECT * FROM x UNION ALL SELECT * FROM x),
z(id) AS
(SELECT * FROM y UNION ALL SELECT id+1 FROM z WHERE id < 10)
SELECT * FROM z;
- Fix some cases where target list has subquries
WITH RECURSIVE t(id) AS (
SELECT (VALUES(1))
UNION ALL
SELECT id+1 FROM t WHERE id < 5
)
SELECT * FROM t;
Remaining works:
1) write sgml docs
2) write README
Currently I'm writing 2) based on the one posted before.
BTW, I'm traveling to the United States from Aug 4 to Aug 12. I'm
going to join Linux World, PGDay and pgpool party at Bruce's. I hope
to meet many community poeple soon!
--
Tatsuo Ishii
SRA OSS, Inc. Japan
Attachment | Content-Type | Size |
---|---|---|
recursive_query.patch.gz | application/octet-stream | 30.3 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-08-03 04:14:16 | Re: Parsing of pg_hba.conf and authentication inconsistencies |
Previous Message | Robert Treat | 2008-08-03 02:30:18 | Re: Parsing of pg_hba.conf and authentication inconsistencies |
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2008-08-06 15:37:27 | Re: [HACKERS] get_relation_stats_hook() |
Previous Message | Simon Riggs | 2008-08-02 19:12:50 | Re: WIP: Transportable Optimizer Mode |