<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<div class="MsoNormal elementToProof" style="margin: 0px 0in 10.6667px; line-height: 107%; font-size: 12pt; font-family: Arial, sans-serif;">
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in">
Dear Recipient!<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in">
I hope this mail finds you in good health and enjoying your life.<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in">
<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in;text-align:justify">
I am Faqir Hussain, an MS student at National University of Sciences and Technology. I am working on MobilityDB as my research work of MS. I am quite new to this platform. Previously I have worked on MS SQL Server and PostgreSQL. I have gone through some of
its stuff including Research Papers, Tutorial Videos etc. Right now, I have prepared my machine to work on MobilityDB using Docker Desktop (as per instructions available on
<a href="https://github.com/MobilityDB/MobilityDB-docker">https://github.com/MobilityDB/MobilityDB-docker</a>). I have installed two version of MobilityDB:<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in;text-align:justify">
<o:p> </o:p></p>
<ol style="margin-bottom:0in">
<li>MobilityDB Latest<o:p> </o:p></li><li>MobilityDB Berlin Mode (codewit/mobilitydb)<o:p> </o:p></li></ol>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in">
<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in">
Both are working here, but I found some of the issues like:<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in">
<span style="font-size:10.0pt;font-family:"Source Code Pro""><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in">
<span style="font-size:10.0pt;font-family:"Source Code Pro"">SELECT duration(period '[2012-01-01, 2012-01-03)');
<o:p> </o:p></span></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in">
<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in">
This query produces error on both versions as given below:<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in">
<span style="font-size:9.5pt;font-family:"Source Code Pro";color:#222222;background:white"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in">
<span style="font-size:9.5pt;font-family:"Source Code Pro";color:#222222;background:white">ERROR: function duration(period) does not exist LINE 1: SELECT duration(period '[2012-01-01, 2012-01-03)'); ^ HINT: No function matches the given name and argument types.
You might need to add explicit type casts. SQL state: 42883 Character: 8</span> <o:p>
</o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in">
<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in">
I would request to guide me how to resolve it. <o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in">
<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in">
<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in">
<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in">
With regards,<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in">
<o:p><br>
</o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in">
<o:p><br>
</o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in">
Faqir Hussain<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in">
IGIS-SCEE-NUST<o:p> </o:p></p>
<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:12pt;margin-bottom:0in">
Islamabad, Pakistan<o:p> </o:p></p>
<br>
</div>
</div>
</body>
</html>