john darnell <john.darn...@walsworth.com> писал(а) в своём письме Wed, 08 Dec 2010 02:23:53 +0600:
> I cannot find a reference to "enum" in any SQLite documentation. Hmm. > I suppose I could write a quick little function and use it as the > Default... Hmm, there is a useful function called "ELT" in some databases, it could work for you. For example, ELT(myfield,'alpha','beta','gamma') would return 'alpha' if myfield=1, 'beta' if myfield=2 and 'gamma' if myfield=3. The reverse function to ELT is FIELD, for example, FIELD(myvalue,'alpha','beta','gamma') would return 2 if myvalue='beta'. Although, I'm not sure once again if SQLite supports these two functions (I'm only getting familiar with SQLite myself). > On a completely off-topic subject, Mr. Igitov, your moniker is > Dagdamor...for a moment there I thought you might be Irish Celt (Dagda > meaning "the good father" and was a principle Irish god in olden times), > but "Igitov" kinda makes me think otherwise. Chat with me offline > (meaning, "outside the list") if you are interested in pursuing this > wholly trivial but still interesting topic. *Dagdamor scratches head* It's really just a nickname, not more. :) I'm from Russia and can only dream about warm typical Celtic weather or Irish beer holidays... Sorry for speaking off-topic :) > > R, > John > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Regards, Serge Igitov _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
