<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="gmail_signature" data-smartmail="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="gmail_quote"><div dir="ltr" class="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="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="MsoNormal" style="margin:0px 0in 10.6667px;line-height:107%;font-size:12pt;font-family:Arial,sans-serif">
<p class="MsoNormal" style="margin:0in;line-height:107%;font-size:12pt">
Dear Recipient!<u></u> <u></u></p>
<p class="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="MsoNormal" style="margin:0in;line-height:107%;font-size:12pt">
<u></u> <u></u></p>
<p class="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="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="MsoNormal" style="margin:0in;line-height:107%;font-size:12pt">
<u></u> <u></u></p>
<p class="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="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="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="MsoNormal" style="margin:0in;line-height:107%;font-size:12pt">
<u></u> <u></u></p>
<p class="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="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="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="MsoNormal" style="margin:0in;line-height:107%;font-size:12pt">
<u></u> <u></u></p>
<p class="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="MsoNormal" style="margin:0in;line-height:107%;font-size:12pt">
<u></u> <u></u></p>
<p class="MsoNormal" style="margin:0in;line-height:107%;font-size:12pt">
<u></u> <u></u></p>
<p class="MsoNormal" style="margin:0in;line-height:107%;font-size:12pt">
<u></u> <u></u></p>
<p class="MsoNormal" style="margin:0in;line-height:107%;font-size:12pt">
With regards,<u></u> <u></u></p>
<p class="MsoNormal" style="margin:0in;line-height:107%;font-size:12pt">
<u></u><br>
<u></u></p>
<p class="MsoNormal" style="margin:0in;line-height:107%;font-size:12pt">
<u></u><br>
<u></u></p>
<p class="MsoNormal" style="margin:0in;line-height:107%;font-size:12pt">
Faqir Hussain<u></u> <u></u></p>
<p class="MsoNormal" style="margin:0in;line-height:107%;font-size:12pt">
IGIS-SCEE-NUST<u></u> <u></u></p>
<p class="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>