[sqlite] REGEX

2008-06-07 Thread Alyssa Papalopa
Has anybody developed a function to support REGEX? _ Now you can invite friends from Facebook and other groups to join you on Windows Liveā„¢ Messenger. Add now. https://www.invite2messenger.net/im/?source=TXT_EML_WLH_AddNow_Now

Re: [sqlite] SQLite bug on AFP?

2008-06-07 Thread D. Richard Hipp
On Jun 7, 2008, at 4:40 PM, Peter K. Stys wrote: > On Thu, Jun 5, 2008 at 2:04 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > >> >> On Jun 5, 2008, at 12:09 PM, Shawn Wilsher wrote: >> >>> Hey all, >>> >>> We are getting reports that sqlite is not working for users of AFP >>> (Apple Filing

Re: [sqlite] SQLite bug on AFP?

2008-06-07 Thread Peter K. Stys
On Thu, Jun 5, 2008 at 2:04 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > > On Jun 5, 2008, at 12:09 PM, Shawn Wilsher wrote: > > > Hey all, > > > > We are getting reports that sqlite is not working for users of AFP > > (Apple Filing Protocol) in Bug 417037 [1]. I was wondering if this > >

Re: [sqlite] Select problem with equal compare

2008-06-07 Thread Alexey Pechnikov
> Please read the recent thread "What is quicker" which has a long > discussion on the limitations of floating point. > > A short summary might be, "Unless you assume that any value stored in > floating point format is only an approximation to the input value, you > will run into trouble sooner or

Re: [sqlite] Select problem with equal compare

2008-06-07 Thread Gerry Snyder
Alexey Pechnikov wrote: > 1. I try to select: > > sqlite> select save_date from photo_tags where save_date<2454612.21079943 > limit 1 offset 3073; > save_date = 2454612.21079943 > > But 2454612.21079943<2454612.21079943 is wrong result. > > 2 > Please read the recent thread "What is

[sqlite] Select problem with equal compare

2008-06-07 Thread Alexey Pechnikov
1. I try to select: sqlite> select save_date from photo_tags where save_date<2454612.21079943 limit 1 offset 3073; save_date = 2454612.21079943 But 2454612.21079943<2454612.21079943 is wrong result. 2. And I try sqlite> select save_date from photo_tags where save_date=2454612.21079943;

[sqlite] rtree extension question

2008-06-07 Thread Christophe Leske
Hi, i am now using the rtree extension in my project, yet still see some slowdown for some scenarios (especially for searches in narrow/small rectangles). I was therefore wondering if... - one can somehow index the fields of an rtree table, and if so how? - if there could be any other