Hi,
Say the scenario is
column value = [1,2,33,45,66]
u want to compare value x with the column and retrieve data then use the
condition,
value = 'x' OR value LIKE 'x,%' OR value LIKE '%,x,%' OR value LIKE '%,x'
it should work in most of the cases (y)
Thanks,
Supriya
--
View this message i
Hi,
Say the scenario is
column value = [1,2,33,45,66]
u want to compare value x with the column and retrieve data then use the
condition,
value = 'x' OR value LIKE 'x,%' OR value LIKE '%,x,%' OR value LIKE '%,x'
it should work in most of the cases (y)
Thanks,
Supriya
--
View this message i
On Mon, Apr 7, 2014 at 5:28 PM, Dominique Devienne wrote:
> So the only piece
> that's missing is an official way to use vtables "on the fly", and
> pass in to its xFilter method the value from the left-correlated value
> for each joined left value, so the resulting cursor can "iterate" the
> righ
Hello,
thus, good, incident closed, we've seen worse; I guess, the
misunderstanding was triggered by not following up and well on the lipstick
8-p
Best.
On Mon, Apr 7, 2014 at 4:27 PM, RSmith wrote:
> On 2014/04/08 01:02, David Simmons wrote:
>
>> Why are these people allowed to use this disc
On 2014/04/08 01:02, David Simmons wrote:
Why are these people allowed to use this discussion board?
Using SQLite on a critical corporation application I find that by reading the
material provided it
is handling terabyte databases with remarkable performance. SQLite does not
have the
cost ass
On Apr 8, 2014, at 1:02 AM, David Simmons wrote:
> Why are these people allowed to use this discussion board?
Hmmm? What we've got here is failure to communicate perhaps.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/
Why are these people allowed to use this discussion board?
Using SQLite on a critical corporation application I find that by reading the
material provided it
is handling terabyte databases with remarkable performance. SQLite does not
have the
cost associated with one like Oracle and does not
"But if the Customer can't tell the difference, does that make you a good
pimp?"
Hello,
you just don't get it then you don't get it, that's it.
Best Regards
On Mon, Apr 7, 2014 at 12:09 PM, RSmith wrote:
>
> On 2014/04/07 20:57, Petite Abeille wrote:
>
>> Lipstick Driven Design: “You can pu
On 2014/04/07 20:57, Petite Abeille wrote:
Lipstick Driven Design: “You can put lipstick on a pig, but it’s still a pig.”
But if the Customer can't tell the difference, does that make you a good pimp?
___
sqlite-users mailing list
sqlite-users@sqli
On Apr 7, 2014, at 8:48 PM, mm.w <0xcafef...@gmail.com> wrote:
> Dear Petite Abeille, you may repeat it 1 times, they don't listen, they
> prefer adding to the previous mistake instead of fixing the origin (hiding
> behind falsehood constraints, like it is way it is...) until it will fall
> a
Hello,
Dear Petite Abeille, you may repeat it 1 times, they don't listen, they
prefer adding to the previous mistake instead of fixing the origin (hiding
behind falsehood constraints, like it is way it is...) until it will fall
apart with unsolvable issues and developer-made-bugs, surely that'
On Apr 7, 2014, at 3:28 PM, Dominique Devienne wrote:
> For those interested, here's an article along the same lines that
> better demonstrate what I mean by the above:
>
> http://technology.amis.nl/2013/06/26/oracle-database-12c-joining-and-outer-joining-with-collections/
Aha! That’s what tha
On Sun, Apr 6, 2014 at 8:15 PM, Dominique Devienne wrote:
> [...]. I'd much prefer a cleaner Oracle-like TABLE()
> operator transforming the result array of a table-function operating
> on correlated values from a join as an intermediate result-set, i.e.
>
> select t.key, csv.COLUMN_VALUE from tab
On Sun, Apr 6, 2014 at 10:23 PM, Dominique Devienne wrote:
>
> If the answer to either question above is true, then a specialized
> vtable would be both more convenient and faster, no?
>
Hmm... If logical peculiarity of vtable approach (when
where-constrained queries might be larger than full-sc
On Sat, Apr 5, 2014 at 11:46 AM, RSmith wrote:
> WITH csvrec(i,l,c,r) AS (
> SELECT tmpcsv.ID, 1, colCSV||',', '' FROM tmpcsv
> UNION ALL
> SELECT i,
> instr(c,',') AS vLen,
> substr(c,instr(c,',')+1) AS vRem,
> substr(c,1,instr(c,',')-1) AS
On Sun, Apr 6, 2014 at 6:13 PM, Hick Gunter wrote:
> The vtable split method will happily accept a field from a join as in
>
> Select t.key,c.value from table t cross join cmlist on c.commalist=t.field;
Thanks. Given Max's other post, I now understand that, although I'll
have to code it myself to
liche Nachricht-
Von: Dominique Devienne [mailto:ddevie...@gmail.com]
Gesendet: Samstag, 05. April 2014 10:24
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] comma-separated string data
On Saturday, April 5, 2014, Max Vlasov wrote:
> On Fri, Apr 4, 2014 at 10:20 PM, peter
CREATE TABLE tmpcsv (
ID INTEGER PRIMARY KEY,
colA TEXT,
colCSV TEXT
);
INSERT INTO tmpcsv (colA, colCSV) VALUES
('foo', '4,66,51,3009,2,678'),
('bar', 'Sputnik,Discovery'),
('baz', '101,I-95,104');
WITH csvrec(i,l,c,r) AS (
SELECT tmpcsv.ID, 1, colCSV||',', '' FROM tmpcsv
On Saturday, April 5, 2014, Max Vlasov wrote:
> On Fri, Apr 4, 2014 at 10:20 PM, peter korinis
> >
> wrote:
> > A data column in a link table contains comma-separated string data, where
> >
> > How do you 'parse' a table entry like: "4,66,51,3009,2,678, ." to extract
> > these values and use the
On Fri, Apr 4, 2014 at 10:20 PM, peter korinis wrote:
> A data column in a link table contains comma-separated string data, where
>
> How do you 'parse' a table entry like: "4,66,51,3009,2,678, ." to extract
> these values and use them in an SQL statement, perhaps a WHERE id='66'?
>
>
In similar
On Fri, 4 Apr 2014 14:20:57 -0400
"peter korinis" wrote:
> How do you 'parse' a table entry like: "4,66,51,3009,2,678, ." to
> extract these values and use them in an SQL statement, perhaps a
> WHERE id='66'?
http://www.schemamania.org/sql/#lists
HTH, really.
--jkl
_
On 4/4/2014 4:12 PM, peter korinis wrote:
Does SQL have any string commands, like REGEXP or something else to
strip out the commas, and transform the string into multiple discrete
values, then use those perhaps in a SQL subquery . or something like
that?
Do the processing outside of SQLite.
Le
Thanks, Simon.
The database was created by a developer as part of a larger project
involving a mobile app and portal. the portal is written in which calls the
db. so that's where the 'parsing' is done. But unfortunately a SQL alone
cannot provide the data in this case. This portal is in production
On 4 Apr 2014, at 7:20pm, peter korinis wrote:
> How do you 'parse' a table entry like: "4,66,51,3009,2,678, ." to extract
> these values and use them in an SQL statement, perhaps a WHERE id='66'?
This is not simple, and would lead to slow execution in a live environment.
Are you willing, at t
peter korinis wrote:
> A data column in a link table contains comma-separated string data, where
> each value represents a value to link to another table. (many-to-many
> relationship)
Every time you use non-normalized data ... God kills a kitten.
> How do you 'parse' a table entry like: "4,66,51
A data column in a link table contains comma-separated string data, where
each value represents a value to link to another table. (many-to-many
relationship)
How do you 'parse' a table entry like: "4,66,51,3009,2,678, ." to extract
these values and use them in an SQL statement, perhaps a WHERE
You need to normalize the database design.
--
On Fri, 2014-04-04 at 14:20 -0400, peter korinis wrote:
> A data column in a link table contains comma-separated string data, where
> each value represents a value to link to another table. (many-to-many
> relationship)
>
>
>
> How do you 'parse'
27 matches
Mail list logo
