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 AT lists.sourceforge DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users