On Tue, Feb 17, 2009 at 10:41:42PM +0300, Alexey Pechnikov scratched on the
wall:
> Hello!
>
> ? ????????? ?? Tuesday 17 February 2009 22:01:38 Jay A. Kreibich ???????(?):
> > > 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.
>
> It's work.
Sure does. Must have missed this change. Seems DEFAULTs can be
expressions as long as they're in ()s.
That will sure make life a lot easier.
-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
