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 join.
The closest you
Hello,
Is there a version of "LIKE", in SQLite, which makes it clear that we
only care to have a pattern on the postfix of a column?
An example follows:
select * from a,b where POSTFIX_LIKE(a.c1, b.c1 ,'%');
In above example, POSTFIX_LIKE works in the same way as if we had written:
select *
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 sa
[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
tuation.
-- James
> -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
>
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
someth
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
> ca
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
error:
/ptmp/bld/> make install
tclsh ../sqlite-3.3.17/tclinstall
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,
MYS
ested
contact [EMAIL PROTECTED]
-Original Message-
From: Scott Hess [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 01, 2007 2:36 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Prefix searching for fts2.
I just finished ( http://www.sqlite.org/cvstrac/chngview?cn=3893 )
checking in a string o
I just finished ( http://www.sqlite.org/cvstrac/chngview?cn=3893 )
checking in a string of changes to fts2.c to provide prefix search.
This works like:
CREATE VIRTUAL TABLE t USING fts2(c);
INSERT INTO t (c) VALUES ('This is a test');
INSERT INTO t (c) VALUES ('That was a test');
INSERT INTO
12 matches
Mail list logo