| 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: | Whole Thread | Raw Message | 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 |