<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<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);">
Thank you so much sir. My issue is resolved.</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Esteban Zimanyi <estebanzimanyi@gmail.com><br>
<b>Sent:</b> Saturday, April 9, 2022 12:43 PM<br>
<b>To:</b> FAQIR HUSSAIN <fhussain.ms20igis@student.nust.edu.pk><br>
<b>Cc:</b> mobilitydb-users@lists.osgeo.org <mobilitydb-users@lists.osgeo.org><br>
<b>Subject:</b> Re: [Mobilitydb-users] New to MobilityDB</font>
<div> </div>
</div>
<div>
<div dir="ltr">Dear Faqir
<div><br>
</div>
<div>Maybe you could install the latest develop version from sources</div>
<div><a href="https://github.com/MobilityDB/MobilityDB#building--installation">https://github.com/MobilityDB/MobilityDB#building--installation</a></div>
<div>instead of using docker image. This is the version that will be used for the official 1.0 release in the forthcoming days. </div>
<div><br>
</div>
<div>test=# SELECT duration(period '[2012-01-01, 2012-01-03)');<br>
duration<br>
----------<br>
2 days<br>
(1 row)<br>
</div>
<div><br>
</div>
<div>Regards</div>
<div><br>
</div>
<div>Esteban</div>
<div>
<div>
<div dir="ltr" class="x_gmail_signature">
<div dir="ltr">
<div>------------------------------------------------------------<br>
Prof. Esteban Zimanyi<br>
Department of Computer & Decision Engineering (CoDE) CP 165/15 <br>
Universite Libre de Bruxelles <br>
Avenue F. D. Roosevelt 50 <br>
B-1050 Brussels, Belgium <br>
fax: + 32.2.650.47.13<br>
tel: + 32.2.650.31.85<br>
e-mail: <a href="mailto:esteban.zimanyi@ulb.be" target="_blank">esteban.zimanyi@ulb.be</a><br>
Internet: <a href="http://cs.ulb.ac.be/members/esteban/" target="_blank">http://cs.ulb.ac.be/members/esteban/</a><br>
------------------------------------------------------------</div>
</div>
</div>
</div>
<br>
</div>
</div>
<br>
<div class="x_gmail_quote">
<div dir="ltr" class="x_gmail_attr">On Sat, Apr 9, 2022 at 9:07 AM FAQIR HUSSAIN <<a href="mailto:fhussain.ms20igis@student.nust.edu.pk">fhussain.ms20igis@student.nust.edu.pk</a>> wrote:<br>
</div>
<blockquote class="x_gmail_quote" style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<div dir="ltr">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<div class="x_MsoNormal" style="margin:0px 0in 10.6667px; line-height:107%; font-size:12pt; font-family:Arial,sans-serif">
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt">Dear Recipient!<u></u> <u></u></p>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt">I hope this mail finds you in good health and enjoying your life.<u></u> <u></u></p>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt"><u></u> <u></u></p>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt; 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" target="_blank">https://github.com/MobilityDB/MobilityDB-docker</a>). I have installed two version of MobilityDB:<u></u> <u></u></p>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt; text-align:justify">
<u></u> <u></u></p>
<ol style="margin-bottom:0in">
<li>MobilityDB Latest<u></u> <u></u></li><li>MobilityDB Berlin Mode (codewit/mobilitydb)<u></u> <u></u></li></ol>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt"><u></u> <u></u></p>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt">Both are working here, but I found some of the issues like:<u></u> <u></u></p>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt"><span style="font-size:10pt; font-family:"Source Code Pro""><u></u> <u></u></span></p>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt"><span style="font-size:10pt; font-family:"Source Code Pro"">SELECT duration(period '[2012-01-01, 2012-01-03)');
<u></u> <u></u></span></p>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt"><u></u> <u></u></p>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt">This query produces error on both versions as given below:<u></u> <u></u></p>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt"><span style="font-size:9.5pt; font-family:"Source Code Pro"; color:rgb(34,34,34); background:white"><u></u> <u></u></span></p>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt"><span style="font-size:9.5pt; font-family:"Source Code Pro"; color:rgb(34,34,34); 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>
<u></u> <u></u></p>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt"><u></u> <u></u></p>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt">I would request to guide me how to resolve it.
<u></u> <u></u></p>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt"><u></u> <u></u></p>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt"><u></u> <u></u></p>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt"><u></u> <u></u></p>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt">With regards,<u></u> <u></u></p>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt"><u></u><br>
<u></u></p>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt"><u></u><br>
<u></u></p>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt">Faqir Hussain<u></u> <u></u></p>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt">IGIS-SCEE-NUST<u></u> <u></u></p>
<p class="x_MsoNormal" style="margin:0in; line-height:107%; font-size:12pt">Islamabad, Pakistan<u></u> <u></u></p>
<br>
</div>
</div>
</div>
_______________________________________________<br>
Mobilitydb-users mailing list<br>
<a href="mailto:Mobilitydb-users@lists.osgeo.org" target="_blank">Mobilitydb-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/mobilitydb-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/mobilitydb-users</a><br>
</blockquote>
</div>
</div>
</body>
</html>