On 22 Jul 2012, at 16:37, Pavel Ivanov wrote:
> You can execute "select strftime('%s', 'now')" first and then put its
> result into your query.
It seems as though the opinion is that it may execute multiple times.
> But that won't work with view, of course.
I'd rather keep the alias_info view as it is because it's simple - I prefer DB
logic to be in the DB, rather than the PHP script.
I'm toying with the idea of creating a temporary table with the current time in
and selecting from that in the latest_alias subquery, but would prefer
better/cleaner options.
Thanks,
Kevin Martin
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
