Gabriel Cook wrote:
> Thanks for your reply.
>
> However, I can't normalize the data in the blob, basically, its an
arbitrary
> frame of data. I don't know what's in it or how its formatted at design
> time.
>
> I'm ok with the table scan, IF I there is any way I can get the query to
> work. I'l
Gabriel Cook wrote:
Thanks for your reply.
However, I can't normalize the data in the blob, basically, its an arbitrary
frame of data. I don't know what's in it or how its formatted at design
time.
I'm ok with the table scan, IF I there is any way I can get the query to
work. I'll have to sc
On Fri, Nov 03, 2006 at 11:39:47AM -0600, Gabriel Cook wrote:
> So, is there any way to of thing with a BLOB?
>
> > WHERE substr(data, 1, 1) == x'bc'
This works:
WHERE substr(data, 1, 1) == CAST(X'...' AS TEXT);
but only as long as X'...' has no NULs. And probably only as lon as
data contains
: Isaac Raway [mailto:[EMAIL PROTECTED]
Sent: Friday, November 03, 2006 9:48 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Using BLOBs in where fields
If you can get this to work it will be very slow. I suggest when writing to
this table that you extract the relevant parts of the data blob
If you can get this to work it will be very slow. I suggest when writing to
this table that you extract the relevant parts of the data blob and store
them in separate fields with an appropriate index on each each . This will
avoid the a table scan for every query, which is what you'd get if your
e
Hello all,
I'm trying to figure out if there is a way use portions of a BLOB field in a
select query.
Here is an example of the table:
CREATE TABLE fcdata (
timestamp INTEGER NOT NULL,
portINTEGER NOT NULL,
dataelementtype INTEG
6 matches
Mail list logo