On Tue, Feb 17, 2009 at 09:52:36PM +0300, Alexey Pechnikov scratched on the
wall:
> I think you can to try
>
> 1. Replace date date, time time to single REAL field:
> date REAL NOT NULL DEFAULT (julianday('now'))
That's not going to do what you think it is going to do.
DEFAULTs are *literals*, not expressions.
-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
