R Smith wrote
> it would be nice to have
> an XOR operator in the way that & and | work... Is there any character
> left to use, or one that are regularly used as XOR in other languages?
> The $ sign seems to be free, but it would be nice to conform to some
> standard. Perhaps a combined
I know steps were taken to reduce it, but just confirming it is still going
on today.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
I have read the excellent page:
https://www.sqlite.org/lockingv3.html
I was hoping someone could clarify/confirm the behavior during the
following steps.
On a Windows PC, if I have a SQLite DB open (using system.data.sqlite if
that is an important fact) over a Windows network share, here are the
Looks right to me anyway. I'm under the impression that network share locking
can be sketchy, but you did say "expected".
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Denis Burke
Sent: Friday, April 27, 2018 2:52 PM
To: SQLite
Hi All,
We have a requirement where in offset of the primary key ID is needed as per
the sorted list.
Table:
ID NAME
1 AAA
2 ZZZ
3 BBB
4 WWW
5 CCC
Now need to get the offset of the ID 3 in the sorted list of the NAME.
SELECT * FROM TABLE ORDER BY NAME ASC
SELECT COUNT(*)+1 FROM TABLE WHERE NAME < (SELECT NAME FROM TABLE WHERE ID = 3)
(I think)
From: sqlite-users on behalf of
Hegde, Deepakakumar (D.)
Sent: Friday, April 27, 2018 3:51:27
create table data (id integer primary key, name text);
insert into data (name) values ('AAA'), ('ZZZ'), ('BBB'), ('WWW'), ('CCC');
select * from data;
1|AAA
2|ZZZ
3|BBB
4|WWW
5|CCC
select * from data order by name;
1|AAA
3|BBB
5|CCC
4|WWW
2|ZZZ
create table temp.ranked as select * from data
Again, requiring that both "id" and "name" are candidate keys. In which case,
since there has to be unique indexes to enforce that, one might use the more
straightforward:
select count(*) from table where name <= (select name from table where id=?)
order by name;
---
The fact that there's
On 27 April 2018 at 15:51, Hegde, Deepakakumar (D.)
wrote:
> Hi All,
>
> We have a requirement where in offset of the primary key ID is needed as per
> the sorted list.
.
.
.
> 1 AAA
> 3 BBB
> 5 CCC
> 4 WWW
> 2 ZZZ
>
> So position of ID 3 as per the sorted
The constraint, obviously, being that "id" and "name" are each candidate keys
...
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
I have never run into this issue myself.
However, you do not specify the version or Platform (Windows , Linux
(plus distribution), Other (Apple iOS, MVS, BSD, etc).
Nor the version of CPython nor from whence it came (preloaded? version?
Downloaded and installed yourself? Built
How about
SELECT ID,NAME,
(SELECT COUNT(*) FROM TABLE WHERE NAME<=(SELECT NAME FROM TABLE WHERE ID=d.ID))
as Position
FROM TABLE d
ORDER BY ID;
sqlite> create table t(ID,name text);
sqlite> insert into t values (1,'AAA'),(2,'ZZZ'),(3,'BBB'),(4,'WWW'),(5,'CCC');
sqlite> select
I've got a working site, but I made a copy of the database in order to do
some development work.
I've hit a snag that looks like a problem in the data.
Ive written a management command to show the problem:
from django.core.management.base import BaseCommand, CommandError
# Stuff for the library
Oops. Wrong list. Should go to a Django group. I noticed as soon as I
sent this. Please ignore.
On Fri, Apr 27, 2018 at 2:58 PM, Kevin O'Gorman
wrote:
> I've got a working site, but I made a copy of the database in order to do
> some development work.
> I've hit a
http://www.sqlite.org/howtocorrupt.html
2018-04-27 23:58 GMT+02:00, Kevin O'Gorman:
> I've got a working site, but I made a copy of the database in order to do
> some development work.
> I've hit a snag that looks like a problem in the data.
>
> Ive written a management command to show the
On 27-4-2018 20:57, Denis Burke wrote:
> I know steps were taken to reduce it, but just confirming it is still going
> on today.
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
>
16 matches
Mail list logo