Well this is one step forward for Postgres, though it would require a 
database change ...

Now lets see what comes up for MySQL

Best regards,
Kern

On 02/19/2016 03:16 AM, Dimitri Maziuk wrote:
> On 02/18/2016 08:44 AM, Phil Stracchino wrote:
>> On 02/18/16 09:38, Dimitri Maziuk wrote:
>>> MySQL can disagree with whatever it wants, but INTERVAL is an ANSI
>>> SQL-92 *datatype* and the link you posted describes a bunch of
>>> *functions* with no hint of standards compliance. There is a difference.
>>
>> I'm sorry, I misunderstood.  I didn't realize we were talking about
>> different things.
>
> Specifically, I believe #3 below won't work in mysql:
>
> 1. User asked for ExpiresIn column to display something more useful than
> an integer.
>
> 2. Bacula would do it if there was a way that worked in all supported
> databases.
>
> 3. The standard way is to "CREATE TABLE media (... lastwritten
> timestamp, volretention INTERVAL, ..." and then "SELECT ... lastwritten
> + volretention as ExpiresOn ..."
>
> 4. The intersection of "databases that support that part of the
> standard" and "databases supported by bacula" is postgresql.
>
> AFAIK, ICBW, and all that.
>
>
>
> ------------------------------------------------------------------------------
> 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