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
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
[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
>
-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??
>
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
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-
>
> -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
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,
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
9 matches
Mail list logo