Re: Cool hack with recursive queries

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: David Fetter <david(at)fetter(dot)org>, David Rowley <dgrowley(at)gmail(dot)com>, "'Gregory Stark'" <stark(at)enterprisedb(dot)com>, "'Postgres'" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Cool hack with recursive queries
Date: 2008-11-21 20:06:13
Message-ID: 492714B5.8070806@sun.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera napsal(a):
> David Fetter escribió:
>> On Wed, Nov 19, 2008 at 10:21:06PM -0000, David Rowley wrote:
>>> Gregory Stark wrote:
>>>> So based on Graeme Job's T-SQL hack over at thedailywtf.com I adapted the
>>>> T-SQL code to Postgres and got this. Thought others might find it amusing.
>>>>
>>> That's pretty amazing.
>>>
>>> I think we should add a regression test with that. :)
>> +1 for adding a regression test :)
>
> It's too slow for that :-(
>

I takes 2.6 second on my laptop. I think it is not so bad.

Zdenek

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2008-11-21 20:17:22 Re: HEAD build failure on win32 mingw
Previous Message Alvaro Herrera 2008-11-21 20:05:07 Re: Re: [COMMITTERS] pgsql: Silence compiler warning about ignored return value.