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@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
