Re: Cool hack with recursive queries

On Fri, Nov 21, 2008 at 09:06:13PM +0100, Zdenek Kotala wrote:
> 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.

About 2.0 on my OS/X laptop.  Could this be a problem on whatever
architecture/OS/compiler combo you have?

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

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