Hello, That may be a solution. I am not particularly worried about SQLite as it is no longer supported. However, what I do need is a patch that will work for both MySQL (MariaDB as well) and PostgreSQL.
Some sort of stored function may also be appropriate. Best regards, Kern On 02/18/2016 10:15 AM, Dimitri Maziuk wrote: > On 02/17/2016 05:58 PM, Kern Sibbald wrote: >> Hello Heitor, >> >> One of the basic design conditions for Bacula is that as much as >> possible that goes into it officially should be understandable and >> maintainable by an average C/C++ programmer. Once things start getting >> complicated, I slow down ... > > ANSI SQL has the interval data type and in a compliant engine > LastWritten + (ExpiresIn * interval '00:00:01') should return a date. (I > think: I've never paid for the privilege of seeing the actual standard.) > The problem is SQL'92 is too big to implement in sqlite and sqlite is > way too convenient to not support. > > > > ------------------------------------------------------------------------------ > Site24x7 APM Insight: Get Deep Visibility into Application Performance > APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month > Monitor end-to-end web transactions and take corrective actions now > Troubleshoot faster and improve end-user experience. Signup Now! > http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 > > > > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
