WITH RECURSIVE patches 0803

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

Browse pgsql-hackers by date

  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

Browse pgsql-patches by date

  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