Eleytherios Stamatogiannakis est...@gmail.com 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 join.
The
-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 start
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-
From
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
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??
-Original Message-
From: James
[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
directory.
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 same
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
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,