add "col4 text" and UPDATE foo SET col4 = col2
keep in mind, other than a few limitations, SQLite doesn't really give a rip about your data types and what you store in it. It is about as free-for-all as it gets. On 3/30/07, Sandeep Suresh <[EMAIL PROTECTED]> wrote:
I have a table : Table foo( col1 integer primary key, *col2 int*, col3 text ) And I want to be able to change this to : Table foo( col1 integer primary key, *col2 text*, col3 text ) I want to do this, because I have an "enum" in col2 and want to be able to use custom collate function and sqlite3 doesn't allow me to use custom collation with integers, which makes sense. I can think of dropping and adding the table back again, any other better ideas out there ? TIA, Sandeep.
-- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation http://www.osgeo.org/education/ --------------------------------------------------------------------- collaborate, communicate, compete ===================================================================== ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------