[Mobilitydb-users] tgeompoint

[Esteban Zimanyi]

There is a function appendInstant to add an instant to an existing temporal
value

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'));
                                                  astext
-----------------------------------------------------------------------------------------------------------
 [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]
(1 row)

You can use the prefix 'srid=XXXX;' in the input string to specify the srid
of the points as in the following example

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'));
                                                       asewkt
---------------------------------------------------------------------------------------------------------------------
 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]
(1 row)

‪On Thu, Mar 18, 2021 at 9:31 AM ‫אריה שטרן‬‎ <arie.stern at hotmail.com>
wrote:‬

> Hi,
>
> Is it possible to add a point to tgeompoint?
>
> Assuming we have tg:
>
> Tg = tegompoint (‘{[(point (0,0)@2001-01-01 08:00:00, Point
> (1,1)@2001-01-01 08:15:00]}’)
>
> And we want to add more point:
>
>                 point (7,6)@2001-01-01 08:30:00
>
> How can we do it?
>
>
>
> How can we define the SRID of tgeompoint?
> TIA
> _______________________________________________
> Mobilitydb-users mailing list
> Mobilitydb-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mobilitydb-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mobilitydb-users/attachments/20210318/f00c7e66/attachment.html>