Funny world that one needs a code of contact to be considered civilized.
No need to defend your CoC.
I see it as a non-exhaustive list of values important to the developers.
That they are Christian-based gives some context for their interpretation.
Can't see any fault in that.
I may or may
email signature Klaus Maas
On 2018-08-30 21:39, Jürgen Palm wrote:
Richard Hipp wrote:
On 8/30/18, Jürgen Palm wrote:
Richard Hipp wrote:
On 8/30/18, Klaus Maas wrote:
Same issues on Xubuntu 16.04 and 18.04
US
for up-arrow and down-arrow.
How do I fix that?
Klaus
email signature Klaus Maas
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org
om test));
d
1
sqlite> create table test2 as
...> select d from (select c as d from (select a as c from test));
sqlite> SELECT * FROM test2;
a <=
1
sqlite>
email signature Klaus Maas
On 2017-12-22 20:11
this
powerful feature.
Still some way to go, but that is part of the fun.
email signature Klaus Maas
On 2017-12-12 00:22, petern wrote:
Klaus. The CTE manual with good examples is at
https://www.sqlite.org/lang_with.html
Thank you for your help!
On 2017-12-11 22:43, Igor Tandetnik wrote:
On 12/11/2017 12:22 PM, Klaus Maas wrote:
There is 1 item in the last where condition of which I do not
understand the purpose:
(instr(subdomain
Thank you, Igor, for your solution.
I expected that I would be pointed to a recursive approach.
Your solution is quite elegant in my opinion.
My problem, however, is that I have not yet understood recursive CTE's.
Could you give me some pointers for good resources to learn about them?
Well, your
I hope someone can help me to improve my SQL.
The solution I came up with becomes unreadable after 3 dots in a website
address (at least for me).
This is my approach:
The domain/subdomain name of a website address is enclosed between '://'
and the following '/'.
So I trim any text before
lan).
The other lines are identical (except for the adjusted subquery count,
of course).
Admittedly, I have VERY little experience interpreting the output of
EXPLAIN QUERY PLAN.
Klaus
email signature Klaus Maas
On 2017-11-17 22
he point I was trying to make and obviously failed was that the string
returned by the select statement nested in the from clause is just a
string which happens to be the same text as the name of a table.
Looking the same does not make it the same.
Klaus
email signature
Yes, correct.
But the contents of the returned table are not objects, but merely values.
In this case the returned table contains a single string value
which happens to be the name of a table, but it is not the table.
Or do I get this wrong?
email signature Klaus Maas Klaus
On 2017
I thought it was because what SQL returns is a value (in this case a
string) and not an object?
The string value might be the same as the name of an object, but is not
the object.
email signature Klaus Maas Klaus
12 matches
Mail list logo