Re: [sqlite] ENUM semantics

At 12:05 AM -0500 3/26/04, Rich Coco wrote: I looked into triggers, but the SQLite implementation did not seem to have the flexibility I needed to implement ENUM. btw - i am not a DB guy at all (tho maybe that will change soon!), so my 'DB/SQL intuitio' is still embryonic. By your suggestion to use

Re: [sqlite] ENUM semantics

At 11:22 PM -0500 3/25/04, Rich Coco wrote: darren - thanks for the response. is this an use for a User Defined Function? Or do I misunderstand the intended uses of UDFs. tx, - rich My understanding is that User Defined Functions are something completely separate. User defined functions allow you

Re: [sqlite] ENUM semantics

At 11:32 AM -0500 3/25/04, rich coco wrote: Used in many places are column definitions like this: replay enum('none','public','private') default NULL, SQLite apprarently does not support the enum keyword? (It's not listed in the 'Datatypes in SQLite' man page). or does it? Hmmm...if ENUM was not

[sqlite] ENUM semantics

I have a pre-existing sql file that I'd like to import into SQLite. (eg, via the .read command of the sqlite command line utility). this sql file creates a bunch of tables. Used in many places are column definitions like this: replay enum('none','public','private') default NULL, SQLite apprarentl