Re: [PATCHES] WITH RECURSIVE patch V0.1
David Fetter <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.general,gmane.comp.db.postgresql.devel.patches |
|---|---|
| Message-ID | <[email protected]> |
On Sat, May 24, 2008 at 03:21:01AM +0900, Yoshiyuki Asaba wrote: > Hi, > > From: David Fetter <[email protected]> > 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 > [email protected] Great! Where is the new patch? Cheers, David. -- David Fetter <[email protected]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [email protected] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers