On Thu, May 06, 2010 at 04:11:43PM +0200, Andy Gibbs scratched on the wall:
> Is it possible to do this in sqlite? No. > I know it would be possible to simply hard-code the default > value into the UPDATE statement, but this would mean when > updating the default in the table declaration, I then need > to make sure all the UPDATEs match! You could extract the default value via PRAGMA table_info(name); Bit of a pain, but it would keep everything in-sync. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Our opponent is an alien starship packed with atomic bombs. We have a protractor." "I'll go home and see if I can scrounge up a ruler and a piece of string." --from Anathem by Neal Stephenson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
