<div dir="ltr"><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div>There is a function appendInstant to add an instant to an existing temporal value<br><br>select asText(appendInstant(tgeompoint '[Point(0 0)@2001-01-01 08:00:00, Point(1 1)@2001-01-01 08:15:00]', 'Point(0 0)@2001-01-01 08:20:00'));<br>                                                  astext<br>-----------------------------------------------------------------------------------------------------------<br> [POINT(0 0)@2001-01-01 08:00:00+01, POINT(1 1)@2001-01-01 08:15:00+01, POINT(0 0)@2001-01-01 08:20:00+01]<br>(1 row)<br><br>You can use the prefix 'srid=XXXX;' in the input string to specify the srid of the points as in the following example<br><br>select asewkt(appendInstant(tgeompoint 'srid=4326;[Point(0 0)@2001-01-01 08:00:00, Point(1 1)@2001-01-01 08:15:00]', 'srid=4326;Point(0 0)@2001-01-01 08:20:00'));<br>                                                       asewkt<br>---------------------------------------------------------------------------------------------------------------------<br> SRID=4326;[POINT(0 0)@2001-01-01 08:00:00+01, POINT(1 1)@2001-01-01 08:15:00+01, POINT(0 0)@2001-01-01 08:20:00+01]<br>(1 row)<br></div></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">‪On Thu, Mar 18, 2021 at 9:31 AM ‫אריה שטרן‬‎ <<a href="mailto:arie.stern@hotmail.com">arie.stern@hotmail.com</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="rtl">
<div style="direction:ltr;font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Hi,</div>
<div style="direction:ltr;font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="direction:ltr;font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<p class="MsoNormal" style="margin:0cm 0cm 8pt;line-height:107%;font-size:11pt;font-family:Calibri,sans-serif">
Is it possible to add a point to tgeompoint?<u></u> <u></u></p>
<p class="MsoNormal" style="margin:0cm 0cm 8pt;line-height:107%;font-size:11pt;font-family:Calibri,sans-serif">
Assuming we have tg:<u></u> <u></u></p>
<p class="MsoNormal" style="margin:0cm 0cm 8pt;line-height:107%;font-size:11pt;font-family:Calibri,sans-serif;text-indent:36pt">
Tg = tegompoint (‘{[(point (0,0)@2001-01-01 08:00:00, Point (1,1)@2001-01-01 08:15:00]}’)<u></u> <u></u></p>
<p class="MsoNormal" style="margin:0cm 0cm 8pt;line-height:107%;font-size:11pt;font-family:Calibri,sans-serif">
And we want to add more point:<u></u> <u></u></p>
<p class="MsoNormal" style="margin:0cm 0cm 8pt;line-height:107%;font-size:11pt;font-family:Calibri,sans-serif">
<span>                </span>point (7,6)@2001-01-01 08:30:00<u></u> <u></u></p>
<p class="MsoNormal" style="margin:0cm 0cm 8pt;line-height:107%;font-size:11pt;font-family:Calibri,sans-serif">
How can we do it?<u></u> <u></u></p>
<p class="MsoNormal" style="margin:0cm 0cm 8pt;line-height:107%;font-size:11pt;font-family:Calibri,sans-serif">
<u></u> <u></u></p>
<p class="MsoNormal" style="margin:0cm 0cm 8pt;line-height:107%;font-size:11pt;font-family:Calibri,sans-serif">
How can we define the SRID of tgeompoint?<u></u> <u></u></p>
TIA</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>