From: | Yoshiyuki Asaba <y-asaba(at)sraoss(dot)co(dot)jp> |
---|---|
To: | david(at)fetter(dot)org |
Cc: | ishii(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org |
Subject: | Re: WITH RECURSIVE patch V0.1 |
Date: | 2008-05-23 18:21:01 |
Message-ID: | 20080524.032101.737004071327915100.y-asaba@sraoss.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Hi,
From: David Fetter <david(at)fetter(dot)org>
Subject: Re: [PATCHES] WITH RECURSIVE patch V0.1
Date: Sun, 18 May 2008 11:47:37 -0700
> I tried a bunch of different queries, and so far, only these two
> haven't worked. Any ideas what I'm doing wrong here?
>
> WITH RECURSIVE t(n) AS (
> SELECT 1
> UNION ALL
> SELECT n+1
> FROM t
> WHERE n < 100
> )
> SELECT * FROM t;
> ERROR: cannot extract attribute from empty tuple slot
Thank you for the report. I've fixed.
postgres=# WITH RECURSIVE t(n) AS (
SELECT 1
UNION ALL
SELECT n+1
FROM t
WHERE n < 100
)
SELECT count(*) FROM t;
count
-------
100
(1 row)
Regards,
--
Yoshiyuki Asaba
y-asaba(at)sraoss(dot)co(dot)jp
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2008-05-23 18:26:30 | Re: WITH RECURSIVE patch V0.1 |
Previous Message | Gurjeet Singh | 2008-05-23 16:20:24 | Random order of archiving files |
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2008-05-23 18:26:30 | Re: WITH RECURSIVE patch V0.1 |
Previous Message | Heikki Linnakangas | 2008-05-23 16:43:55 | Free Space Map rewrite |