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. -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu
signature.asc
Description: OpenPGP digital signature
------------------------------------------------------------------------------ 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
