Re: [sqlite] Prefix joins

Eleytherios Stamatogiannakis wrote: > select * from a,b where a.c1 LIKE b.c1||'%'; > > but with the additional guarantee for the optimizer that all pattern > matching will happen on the postfix and not on the prefix, so the > optimizer will be able to use an index to do the

Re: [sqlite] --prefix

On Tue, 2007-05-29 at 13:11 -0700, Smith1, Robert E wrote: > Hi, > > I am trying to install sqlite3 on Sun Solaris 2.8. I am not root so I > cannot install to /usr/local. I start configure with > --prefix=/ptmp/usr/localto try to get it to install to a different > directory. But I get the

Re: [sqlite] --prefix

[In the message "[sqlite] --prefix" on May 29, 13:11, "Smith1, Robert E" writes:] > Hi, > > I am trying to install sqlite3 on Sun Solaris 2.8. I am not root so I > cannot install to /usr/local. I start configure with > --prefix=/ptmp/usr/localto try to get it to install to a different >

RE: [sqlite] --prefix

-Original Message- > From: Smith1, Robert E [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 29, 2007 1:48 PM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] --prefix > > Why isn't it trying to install to /ptmp/usr/local since that is the > value I gave --prefix?? >

Re: [sqlite] --prefix

I've run into a similar problem today and as far as I can see it has something to do with tcl extensions. If I run configure using --disable-tcl, then my 'make install' puts everything into the location specified using prefix. But in the case of tcl extensions 'make install' attempts to put

RE: [sqlite] --prefix

Why isn't it trying to install to /ptmp/usr/local since that is the value I gave --prefix?? -Original Message- From: James Dennett [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 1:44 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] --prefix > -Original Message- >

RE: [sqlite] --prefix

> -Original Message- > From: Smith1, Robert E [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 29, 2007 1:12 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] --prefix > > Hi, > > I am trying to install sqlite3 on Sun Solaris 2.8. I am not root so I > cannot install to /usr/local. I

Re: [sqlite] Prefix searching for fts2.

On 5/1/07, Samuel R. Neff <[EMAIL PROTECTED]> wrote: One suggestion though, instead of (or in addition to) using '*' as the prefix operator perhaps '%' would be more appropriate in order to be closer to the LIKE operator. Hmm. I was mainly just doing what other groups appear to do (Lucene,

RE: [sqlite] Prefix searching for fts2.

This is great! The main reason we decided not to use FTS in our project was lack of prefix searching. With this new functionality we'll probably switch to using FTS in a future update. One suggestion though, instead of (or in addition to) using '*' as the prefix operator perhaps '%' would be