logo       

How big an integer in SQLite?: msg#00002

python.db.pysqlite.user

Subject: How big an integer in SQLite?

I am used to using a bigint type in postgres in some cases for table
creation. I assume sqlite doesn't care how big the integer gets for an
id. Is this true?

In postgres:

create sequence oid_seq;

create table test (
oid bigint not null primary key,
tid bigint not null
);


In sqlite I am doing this to emulate - since bigint is meaningless in
sqlite and because it will get an auto incremented primary key:

create table test (
oid integer not null primary key,
tid integer not null
);

Regards,
David


<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise