sqlite-users  

[sqlite] Bug getting ROWID datatype?

Tito Ciuro
Fri, 28 May 2004 18:09:05 -0700

Hello,

When I retrieve ROWID's datatype, I get INTEGER. Shouldn't it be INTEGER PRIMARY KEY, the way I created it? The questions arises when performing the ALTER-like operation as shown here:

http://www.sqlite.org/faq.html#q13

If I trust SQLite, then I'll add ROWID with an INTEGER datatype. Will this affect the way SQLite treats ROWID? Or is SQLite smart enough to know that ROWID is a special type of column, therefore treating it as INTEGER PRIMARY KEY?

Thanks,

-- Tito


--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]