Re: [sqlite] windowing functions != recursive functions

2005-10-13 Thread pilot pirx
if there is a sufficient interest. - Original Message - From: [EMAIL PROTECTED] To: sqlite-users@sqlite.org Subject: Re: [sqlite] windowing functions != recursive functions Date: Wed, 12 Oct 2005 22:48:35 -0400 > > "pilot pirx" <[EMAIL PROTECTED]> wrote: > &

[sqlite] wiindow functions and recursive functions

2005-10-12 Thread pilot pirx
-0400 > > On Wed, Oct 12, 2005 at 05:12:05AM -0500, pilot pirx wrote: > > Subject: [sqlite] Please, please do _not_ remove this feature from SQLite... > > > While using SQLite for some time (with R package, www.r-project.org) > > I did admire its functionality and sp

[sqlite] windowing functions != recursive functions

2005-10-12 Thread pilot pirx
previous value(s) of VALUE. - Original Message - From: "Andrew Piskorski" <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Subject: [sqlite] SQL Window/OLAP functions Date: Wed, 12 Oct 2005 08:34:02 -0400 > > On Wed, Oct 12, 2005 at 05:12:05AM -0500, pilot p

Re: [sqlite] SQL Window/OLAP functions

2005-10-12 Thread pilot pirx
: "Andrew Piskorski" <[EMAIL PROTECTED]> > To: <sqlite-users@sqlite.org> > Sent: Wednesday, October 12, 2005 2:34 PM > Subject: [sqlite] SQL Window/OLAP functions > > > > On Wed, Oct 12, 2005 at 05:12:05AM -0500, pilot pirx wrote: > > > Su

[sqlite] Please, please do _not_ remove this feature from SQLite...

2005-10-12 Thread pilot pirx
While using SQLite for some time (with R package, www.r-project.org) I did admire its functionality and speed. Then I did discover a hidden SQLite feature of immense usefulness - not available in other databases. SQLite can compute Fibonacci numbers! (I will explain why this is important