Re: [sqlite] DELETE with 64bit unsigned integer key

Quoth Marco , on 2010-09-28 09:43:17 -0700: > Hello there sqlite-users, > I have a quick question regarding selection and deletion of large unsigned > integers. No, that---what? SQLite doesn't _have_ "unsigned" integers. Read http://sqlite.org/datatype3.html again and come back once you understa

Re: [sqlite] DELETE with 64bit unsigned integer key

On 28 September 2010 17:43, Marco wrote: > Hello there sqlite-users, > I have a quick question regarding selection and deletion of large unsigned > integers. > > I create my table as following: > [1]   CREATE TABLE t1 (instnum BIG UNSIGNED INTEGER PRIMARY KEY,  ...) > > I then insert some row: > [

[sqlite] DELETE with 64bit unsigned integer key

Hello there sqlite-users, I have a quick question regarding selection and deletion of large unsigned integers. I create my table as following: [1] CREATE TABLE t1 (instnum BIG UNSIGNED INTEGER PRIMARY KEY, ...) I then insert some row: [2] INSERT INTO t1 (instnum, ...) VALUES (CAST (?1 AS BIG