Skip site navigation (1) Skip section navigation (2)

Re: WITH RECURSIVE patch V0.1

From: David Fetter <david(at)fetter(dot)org>
To: Yoshiyuki Asaba <y-asaba(at)sraoss(dot)co(dot)jp>
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:26:30
Message-ID: 20080523182630.GA5921@fetter.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On Sat, May 24, 2008 at 03:21:01AM +0900, Yoshiyuki Asaba wrote:
> 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

Great!

Where is the new patch?

Cheers,
David.
-- 
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2008-05-23 19:53:49
Subject: Execution-time-sensitive timestamp regression tests
Previous:From: Yoshiyuki AsabaDate: 2008-05-23 18:21:01
Subject: Re: WITH RECURSIVE patch V0.1

pgsql-patches by date

Next:From: Gregory StarkDate: 2008-05-23 18:55:26
Subject: Re: \d+ should display the storage options for columns
Previous:From: Yoshiyuki AsabaDate: 2008-05-23 18:21:01
Subject: Re: WITH RECURSIVE patch V0.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group