|
How big an integer in SQLite?: msg#00002python.db.pysqlite.user
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> |
|---|---|---|
| Previous by Date: | Re: Test if table is a table in sqlite db: 00002, Tim Golden |
|---|---|
| Next by Date: | Re: Test if table is a table in sqlite db: 00002, David Pratt |
| Previous by Thread: | Test if table is a table in sqlite dbi: 00002, David Pratt |
| Next by Thread: | Re: How big an integer in SQLite?: 00002, Gerhard Häring |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
| News | FAQ | advertise |