mobilitydb / mobilitydb Goto Github PK

mysecretpassword

apt install build-essential cmake postgresql-server-dev-16 libgeos-dev libproj-dev libjson-c-dev libgsl-dev
git clone https://github.com/MobilityDB/MobilityDB
mkdir MobilityDB/build
cd MobilityDB/build
cmake ..
make
sudo make install
shared_preload_libraries = 'postgis-3'
max_locks_per_transaction = 128
ERROR:  could not load library "/usr/local/pgsql/lib/libMobilityDB-1.0.so": undefined symbol: ST_Distance
$ which postgres
/usr/local/pgsql/bin/postgres
$ ls /usr/local/pgsql/data/postgresql.conf
/usr/local/pgsql/data/postgresql.conf
createdb mobility
psql mobility -c "CREATE EXTENSION PostGIS"
psql mobility -c "CREATE EXTENSION MobilityDB"
docker pull mobilitydb/mobilitydb
docker volume create mobilitydb_data
docker run --name mobilitydb -e POSTGRES_PASSWORD=mysecretpassword \
  -p 25432:5432 -v mobilitydb_data:/var/lib/postgresql -d mobilitydb/mobilitydb
psql -h localhost -p 25432 -U postgres
PGPASSWORD=mysecretpassword psql -h localhost -p 25432 -U postgres
cmake -D DOC_ALL=true -D LANG_ALL=true ..
make doc
cmake -D DOC_PDF=true ..
make doc
cmake -D DOC_DEV=true ..
make doc_dev
-- Found PostgreSQL: C:/ming64gcc81/projects/postgresql/rel/pg11w64gcc81/lib/libpq.dll (found version "11.2")
Found 110000
-- WIN32=1
Found compatible 110000 include C:/ming64gcc81/projects/postgresql/rel/pg11w64gcc81/include;C:/ming64gcc81/projects/postgresql/rel/pg11w64gcc81/include/server
Found compatible 11.2
Found share C:/MING64~1/projects/POSTGR~1/rel/PG11W6~1/share lib C:/MING64~1/projects/POSTGR~1/rel/PG11W6~1/lib
-- Found LWGEOM at C:/ming64gcc81/projects/postgis/liblwgeom-2.5w64gcc81/lib/liblwgeom.dll.a include C:/ming64gcc81/projects/postgis/liblwgeom-2.5w64gcc81/include - compiling with PostGIS support
-- Found GSL at C:/ming64gcc81/projects/gsl/rel-gsl-2.6/lib/libgsl.dll.a, Found GSLCBLAS at C:/ming64gcc81/projects/gsl/rel-gsl-2.6/lib/libgslcblas.dll.a
-- Configuring done
-- Generating done
-- Build files have been written to: C:/ming64gcc81/projects/mobility/MobilityDB/build
Scanning dependencies of target sqlscript
[  1%] Generating mobilitydb--1.0-alpha1.sql.c
[  3%] Generating mobilitydb--1.0-alpha1.sql
[  3%] Built target sqlscript
Scanning dependencies of target control
[  5%] Generating mobilitydb.control
[  5%] Built target control
Scanning dependencies of target MobilityDB
[  6%] Building C object CMakeFiles/MobilityDB.dir/src/doublen.c.obj
[  8%] Building C object CMakeFiles/MobilityDB.dir/src/debug/indexesstat.c.obj
[ 10%] Building C object CMakeFiles/MobilityDB.dir/src/lifting.c.obj
[ 11%] Building C object CMakeFiles/MobilityDB.dir/src/oidcache.c.obj
C:/ming64gcc81/projects/mobility/MobilityDB/src/oidcache.c: In function 'populate_oidcache':
C:/ming64gcc81/projects/mobility/MobilityDB/src/oidcache.c:155:3: warning: implicit declaration of function 'bzero' [-Wimplicit-function-declaration]
   bzero(_op_oids, sizeof(_op_oids));
   ^~~~~
C:/ming64gcc81/projects/mobility/MobilityDB/src/oidcache.c:155:3: warning: incompatible implicit declaration of built-in function 'bzero'
[ 13%] Building C object CMakeFiles/MobilityDB.dir/src/period.c.obj
[ 15%] Building C object CMakeFiles/MobilityDB.dir/src/periodset.c.obj
[ 16%] Building C object CMakeFiles/MobilityDB.dir/src/rangetypes_ext.c.obj
[ 18%] Building C object CMakeFiles/MobilityDB.dir/src/tbox.c.obj
[ 20%] Building C object CMakeFiles/MobilityDB.dir/src/temporal.c.obj
[ 22%] Building C object CMakeFiles/MobilityDB.dir/src/temporali.c.obj
[ 23%] Building C object CMakeFiles/MobilityDB.dir/src/temporalinst.c.obj
[ 25%] Building C object CMakeFiles/MobilityDB.dir/src/temporals.c.obj
[ 27%] Building C object CMakeFiles/MobilityDB.dir/src/temporalseq.c.obj
[ 28%] Building C object CMakeFiles/MobilityDB.dir/src/temporal_aggfuncs.c.obj
C:/ming64gcc81/projects/mobility/MobilityDB/src/temporal_aggfuncs.c: In function 'random_level':
C:/ming64gcc81/projects/mobility/MobilityDB/src/temporal_aggfuncs.c:201:9: warning: implicit declaration of function 'ffsl' [-Wimplicit-function-declaration]
  return ffsl(~(random() & ((1l << SKIPLIST_MAXLEVEL) - 1)));
         ^~~~
C:/ming64gcc81/projects/mobility/MobilityDB/src/temporal_aggfuncs.c:201:32: warning: left shift count >= width of type [-Wshift-count-overflow]
  return ffsl(~(random() & ((1l << SKIPLIST_MAXLEVEL) - 1)));
                                ^~
[ 30%] Building C object CMakeFiles/MobilityDB.dir/src/temporal_analyze.c.obj
[ 32%] Building C object CMakeFiles/MobilityDB.dir/src/temporal_boolops.c.obj
[ 33%] Building C object CMakeFiles/MobilityDB.dir/src/temporal_boxops.c.obj
[ 35%] Building C object CMakeFiles/MobilityDB.dir/src/temporal_compops.c.obj
[ 37%] Building C object CMakeFiles/MobilityDB.dir/src/temporal_gist.c.obj
[ 38%] Building C object CMakeFiles/MobilityDB.dir/src/tnumber_mathfuncs.c.obj
[ 40%] Building C object CMakeFiles/MobilityDB.dir/src/temporal_parser.c.obj
[ 42%] Building C object CMakeFiles/MobilityDB.dir/src/temporal_posops.c.obj
[ 44%] Building C object CMakeFiles/MobilityDB.dir/src/temporal_selfuncs.c.obj
[ 45%] Building C object CMakeFiles/MobilityDB.dir/src/temporal_spgist.c.obj
[ 47%] Building C object CMakeFiles/MobilityDB.dir/src/temporal_textfuncs.c.obj
[ 49%] Building C object CMakeFiles/MobilityDB.dir/src/temporal_util.c.obj
[ 50%] Building C object CMakeFiles/MobilityDB.dir/src/temporal_waggfuncs.c.obj
[ 52%] Building C object CMakeFiles/MobilityDB.dir/src/timeops.c.obj
[ 54%] Building C object CMakeFiles/MobilityDB.dir/src/timestampset.c.obj
[ 55%] Building C object CMakeFiles/MobilityDB.dir/src/time_analyze.c.obj
[ 57%] Building C object CMakeFiles/MobilityDB.dir/src/time_gist.c.obj
In file included from C:/ming64gcc81/projects/postgresql/rel/pg11w64gcc81/include/server/postgres.h:46,
                 from C:/ming64gcc81/projects/mobility/MobilityDB/include/time_gist.h:16,
                 from C:/ming64gcc81/projects/mobility/MobilityDB/src/time_gist.c:14:
C:/ming64gcc81/projects/mobility/MobilityDB/src/time_gist.c: In function 'gist_period_double_sorting_split':
C:/ming64gcc81/projects/mobility/MobilityDB/src/time_gist.c:497:44: error: incompatible type for argument 2 of 'period_cmp_bounds'
    Assert(period_cmp_bounds(&lower, context.right_lower) >= 0);
                                     ~~~~~~~^~~~~~~~~~~~
C:/ming64gcc81/projects/postgresql/rel/pg11w64gcc81/include/server/c.h:724:7: note: in definition of macro 'Trap'
   if (condition) \
       ^~~~~~~~~
C:/ming64gcc81/projects/mobility/MobilityDB/src/time_gist.c:497:4: note: in expansion of macro 'Assert'
    Assert(period_cmp_bounds(&lower, context.right_lower) >= 0);
    ^~~~~~
In file included from C:/ming64gcc81/projects/mobility/MobilityDB/src/time_gist.c:21:
C:/ming64gcc81/projects/mobility/MobilityDB/include/period.h:83:75: note: expected 'const PeriodBound *' {aka 'const struct <anonymous> *'} but argument is of type 'PeriodBound' {aka 'struct <anonymous>'}
 extern int period_cmp_bounds(const PeriodBound *lower, const PeriodBound *upper);
                                                        ~~~~~~~~~~~~~~~~~~~^~~~~
make[2]: *** [CMakeFiles/MobilityDB.dir/build.make:484: CMakeFiles/MobilityDB.dir/src/time_gist.c.obj] Error 1
make[1]: *** [CMakeFiles/Makefile2:954: CMakeFiles/MobilityDB.dir/all] Error 2
make: *** [Makefile:141: all] Error 2
[  3%] Built target sqlscript
[  5%] Built target control
[  6%] Building C object CMakeFiles/MobilityDB.dir/src/time_gist.c.obj
In file included from C:/ming64gcc81/projects/postgresql/rel/pg11w64gcc81/include/server/postgres.h:46,
                 from C:/ming64gcc81/projects/mobility/MobilityDB/include/time_gist.h:16,
                 from C:/ming64gcc81/projects/mobility/MobilityDB/src/time_gist.c:14:
C:/ming64gcc81/projects/mobility/MobilityDB/src/time_gist.c: In function 'gist_period_double_sorting_split':
C:/ming64gcc81/projects/mobility/MobilityDB/src/time_gist.c:497:44: error: incompatible type for argument 2 of 'period_cmp_bounds'
    Assert(period_cmp_bounds(&lower, context.right_lower) >= 0);
                                     ~~~~~~~^~~~~~~~~~~~
C:/ming64gcc81/projects/postgresql/rel/pg11w64gcc81/include/server/c.h:724:7: note: in definition of macro 'Trap'
   if (condition) \
       ^~~~~~~~~
C:/ming64gcc81/projects/mobility/MobilityDB/src/time_gist.c:497:4: note: in expansion of macro 'Assert'
    Assert(period_cmp_bounds(&lower, context.right_lower) >= 0);
    ^~~~~~
In file included from C:/ming64gcc81/projects/mobility/MobilityDB/src/time_gist.c:21:
C:/ming64gcc81/projects/mobility/MobilityDB/include/period.h:83:75: note: expected 'const PeriodBound *' {aka 'const struct <anonymous> *'} but argument is of type 'PeriodBound' {aka 'struct <anonymous>'}
 extern int period_cmp_bounds(const PeriodBound *lower, const PeriodBound *upper);
                                                        ~~~~~~~~~~~~~~~~~~~^~~~~
make[2]: *** [CMakeFiles/MobilityDB.dir/build.make:484: CMakeFiles/MobilityDB.dir/src/time_gist.c.obj] Error 1
make[1]: *** [CMakeFiles/Makefile2:954: CMakeFiles/MobilityDB.dir/all] Error 2
make: *** [Makefile:141: all] Error 2

git ls-files | grep '\.sh'
doc/genpotfiles.sh
doc/genxmlfiles.sh
doc/install.sh
test/scripts/print_fail.sh
test/scripts/test.sh
tools/scripts/test_license.sh
tools/scripts/test_shell.sh

3ee2c52
pg_ctl: no operation specified
Try "pg_ctl --help" for more information.

run_ctl () {
  "${BIN_DIR}/pg_ctl" -w -D "$DBDIR" "$@"
  return $?
}

	if ! run_ctl start -l "$WORKDIR/log/postgres.log" -o "$WORKDIR/lock" 2>&1 | tee "$WORKDIR/log/pg_start.log"; then

mobilitydb=# SELECT asText(atValue(tgeompoint '[Point(0 0 0)@2012-01-01, Point(2 2 2)@2012-01-03)', 'Point(1 1 1)'));
                   astext                   
--------------------------------------------
 {[POINT Z (1 1 1)@2012-01-02 00:00:00+00]}
(1 row)

mobilitydb=# SELECT asText(atValue(tgeogpoint '[Point(0 0 0)@2012-01-01, Point(2 2 2)@2012-01-03)', 'Point(1 1 1)'));
 astext 
--------

(1 row)

b38079d
mobtest=# CREATE FUNCTION period_in(cstring)
mobtest-#   RETURNS period
mobtest-#   AS '/home/vicky/mobilitydb/mobilitydb/cvvergara/build/libMobilityDB-1.0.so'
mobtest-#   LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;
NOTICE:  return type period is only a shell
ERROR:  could not load library "/home/vicky/mobilitydb/mobilitydb/cvvergara/build/libMobilityDB-1.0.so": /home/vicky/mobilitydb/mobilitydb/cvvergara/build/libMobilityDB-1.0.so: undefined symbol: getSRSbySRID

In tools/scripts/test_license.sh line 37:
if [[ $missing2 ]]; then
      ^-------^ SC2154: missing2 is referenced but not assigned (did you mean 'missing'?).

In doc/genxmlfiles.sh line 29:
  xmlfilename="$filename.xml"
  ^---------^ SC2034: xmlfilename appears unused. Verify use (or export if used externally).

src/debug/indexesstat.c:27:  Tab found; better to use spaces  [whitespace/tab] [1]
src/debug/indexesstat.c:35:  { should almost always be at the end of the previous line  [whitespace/braces] [4]
src/debug/indexesstat.c:36:  Tab found; better to use spaces  [whitespace/tab] [1]
src/debug/indexesstat.c:37:  Tab found; better to use spaces  [whitespace/tab] [1]
src/debug/indexesstat.c:38:  Tab found; better to use spaces  [whitespace/tab] [1]
src/debug/indexesstat.c:39:  Tab found; better to use spaces  [whitespace/tab] [1]
src/debug/indexesstat.c:40:  Tab found; better to use spaces  [whitespace/tab] [1]
src/debug/indexesstat.c:46:  { should almost always be at the end of the previous line  [whitespace/braces] [4]
src/debug/indexesstat.c:47:  Tab found; better to use spaces  [whitespace/tab] [1]
src/debug/indexesstat.c:48:  Tab found; better to use spaces  [whitespace/tab] [1]
src/debug/indexesstat.c:49:  Tab found; better to use spaces  [whitespace/tab] [1]
src/debug/indexesstat.c:50:  Tab found; better to use spaces  [whitespace/tab] [1]
src/debug/indexesstat.c:51:  Tab found; better to use spaces  [whitespace/tab] [1]
src/debug/indexesstat.c:52:  Tab found; better to use spaces  [whitespace/tab] [1]

void foo() {
  int i;  // tab here (A)
  ++i;  // there are 2 spaces here (B visually sees 2 spaces on the other lines)
  // more code here with tab ( A)
}

int foo() {
      int i;  // tab here (A)
  ++i;  // there are 2 spaces here
      // more code here with tab ( A)
}

In test/scripts/test.sh line 13:
SOFILE="$BUILDDIR/lib@[email protected]"
^----^ SC2034: SOFILE appears unused. Verify use (or export if used externally).

In test/scripts/test.sh line 15:
FAILPSQL="${BIN_DIR}/psql -h $WORKDIR/lock -e --set ON_ERROR_STOP=1 postgres"
^------^ SC2034: FAILPSQL appears unused. Verify use (or export if used externally).

In test/scripts/test.sh line 18:
PGCTL="${BIN_DIR}/pg_ctl -w -D $DBDIR -l $WORKDIR/log/postgres.log -o -k -o $WORKDIR/lock -o -h -o ''"
                                                                                    ^---------------^ SC2089: Quotes/backslashes will be treated literally. Use an array.

In test/scripts/test.sh line 21:
PGSODIR="@POSTGRESQL_DYNLIB_DIR@"
^-----^ SC2034: PGSODIR appears unused. Verify use (or export if used externally).

In test/scripts/test.sh line 44:
  $PGCTL start 2>&1 | tee "$WORKDIR"/log/pg_start.log
  ^----^ SC2090: Quotes/backslashes in this variable will not be respected.

In test/scripts/test.sh line 45:
  if [ "$?" != "0" ]; then
       ^--^ SC2181: Check exit code directly with e.g. 'if mycmd;', not indirectly with $?.

In test/scripts/test.sh line 48:
    $PGCTL status >> "$WORKDIR"/log/pg_start.log
    ^----^ SC2090: Quotes/backslashes in this variable will not be respected.

In test/scripts/test.sh line 49:
    if [ "$?" != "0" ]; then
         ^--^ SC2181: Check exit code directly with e.g. 'if mycmd;', not indirectly with $?.

In test/scripts/test.sh line 61:
  $PGCTL status || $PGCTL start
  ^----^ SC2090: Quotes/backslashes in this variable will not be respected.
                   ^----^ SC2090: Quotes/backslashes in this variable will not be respected.

In test/scripts/test.sh line 72:
    echo "CREATE EXTENSION postgis WITH VERSION '@POSTGIS_VERSION@';" | $PSQL 2>&1 >> "$WORKDIR"/log/create_ext.log
                                                                              ^--^ SC2069: To redirect stdout+stderr, 2>&1 must be last (or use '{ cmd > file; } 2>&1' to clarify).

In test/scripts/test.sh line 74:
  $PSQL -c "SELECT postgis_full_version()" 2>&1 >> "$WORKDIR"/log/create_ext.log
                                           ^--^ SC2069: To redirect stdout+stderr, 2>&1 must be last (or use '{ cmd > file; } 2>&1' to clarify).

In test/scripts/test.sh line 85:
  $PSQL -c "SELECT mobilitydb_full_version()" 2>&1 >> "$WORKDIR"/log/create_ext.log
                                              ^--^ SC2069: To redirect stdout+stderr, 2>&1 must be last (or use '{ cmd > file; } 2>&1' to clarify).

In test/scripts/test.sh line 93:
  $PGCTL stop || true
  ^----^ SC2090: Quotes/backslashes in this variable will not be respected.

In test/scripts/test.sh line 101:
  $PGCTL status || $PGCTL start
  ^----^ SC2090: Quotes/backslashes in this variable will not be respected.
                   ^----^ SC2090: Quotes/backslashes in this variable will not be respected.

In test/scripts/test.sh line 115:
    cat "$WORKDIR"/out/"$TESTNAME".out > $(dirname "$TESTFILE")/../expected/$(basename "$TESTFILE" .sql).out
                                         ^--------------------^ SC2046: Quote this to prevent word splitting.
                                                                            ^--------------------------^ SC2046: Quote this to prevent word splitting.

In test/scripts/test.sh line 121:
    sed -e's/^ERROR:.*/ERROR/' $(dirname "$TESTFILE")/../expected/$(basename "$TESTFILE" .sql).out >> "$tmpexpected"
                               ^--------------------^ SC2046: Quote this to prevent word splitting.
                                                                  ^--------------------------^ SC2046: Quote this to prevent word splitting.

In test/scripts/test.sh line 135:
  $PGCTL status || $PGCTL start
  ^----^ SC2090: Quotes/backslashes in this variable will not be respected.
                   ^----^ SC2090: Quotes/backslashes in this variable will not be respected.

In test/scripts/test.sh line 145:
    @UNCOMPRESS@ "$TESTFILE" | $PSQL 2>&1 >> "$WORKDIR"/out/"$TESTNAME".out
                                     ^--^ SC2069: To redirect stdout+stderr, 2>&1 must be last (or use '{ cmd > file; } 2>&1' to clarify).

cmake .
-- The C compiler identification is GNU 8.4.0
-- The CXX compiler identification is GNU 8.4.0
-- Check for working C compiler: /usr/bin/cc
-- Check for working C compiler: /usr/bin/cc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Detecting C compile features
-- Detecting C compile features - done
-- Check for working CXX compiler: /usr/bin/c++
-- Check for working CXX compiler: /usr/bin/c++ -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- Detecting CXX compile features
-- Detecting CXX compile features - done
...

git status
...
Untracked files:
  (use "git add <file>..." to include in what will be committed)
        CMakeCache.txt
        CMakeFiles/
        CTestTestfile.cmake
        DartConfiguration.tcl
        Makefile
        cmake_install.cmake

cmake .
CMake Error at CMakeLists.txt:4 (message):
  In-source builds not allowed.

          Please make a new directory (called a build directory) and run CMake from there.
          You may need to remove 'CMakeCache.txt' and 'CMakeFiles/'.

-- Configuring incomplete, errors occurred!

In test/scripts/print_fail.sh line 3:
for file in $(find tmptest/log -type f); do
            ^-------------------------^ SC2044: For loops over find output are fragile. Use find -exec or a while read loop.

In test/scripts/print_fail.sh line 12:
for file in $(find tmptest/out -name '*.diff' -type f -not -size 0); do
            ^-- SC2044: For loops over find output are fragile. Use find -exec or a while read loop.

SELECT fid,
tgeogpointseq(atGeometry(flown_path::tgeompoint, geometry 'SRID=4326;POLYGON ((-95.46386763453484 32.87958717306631, -96.67236372828484 31.39115752282473, -96.03515669703484 30.14512718337609, -93.55224654078484 30.58117925738698, -93.06884810328484 33.26624989076275, -95.46386763453484 32.87958717306631))')::tgeompoint)
    FROM table_with_trajectories
    WHERE fid = 20200805523356 ;

C:/ming64gcc81/projects/mobility/MobilityDB/include/temporal.h:113:3: error: expected identifier before '(' token
   SYNCHRONIZE,
   ^~~~~~~~~~~
make[2]: *** [CMakeFiles/MobilityDB.dir/build.make:97: CMakeFiles/MobilityDB.dir/src/doublen.c.obj] Error 1
make[1]: *** [CMakeFiles/Makefile2:1066: CMakeFiles/MobilityDB.dir/all] Error 2
make: *** [Makefile:160: all] Error 2
make: *** No rule to make target 'installcheck'.  Stop.

	cmake  -G "MSYS Makefiles" \
		-DLWGEOM_ROOT:PATH=${LIBLWGEOM_PATH} -DPROJ_INCLUDE_DIR:PATH=${PROJ_PATH}/include \
		-DJSONC_INCLUDE_DIR:PATH=${JSON_PATH}/include \
		-DLIBPROTOBUF_INCLUDE_DIR:PATH=${PROTOBUF_PATH}/include \
		 ..

mobile=# CREATE TABLE Department(DeptNo integer, DeptName varchar(25), NoEmps tint);
CREATE TABLE

mobile=# INSERT INTO Temperature VALUES
(1001, tfloat '{18.5@2012-01-01 08:00:00, 20.0@2012-01-01 08:10:00}'),
(2001, tfloat '{19.0@2012-01-01 08:00:00, 22.5@2012-01-01 08:10:00}');
ERROR:  could not load library "/home/data/local/lib/postgresql/libMobilityDB.so": /home/data/local/lib/postgresql/libMobilityDB.so: undefined symbol: LWGEOM_setpoint_linestring

[wturner@rserver ciws]$ ls -l /home/data/local/lib/postgresql/libMobilityDB.so
-rwxr-xr-x. 1 wturner wturner 1193288 Nov 26 11:00 /home/data/local/lib/postgresql/libMobilityDB.so

[wturner@rserver ~]$ strings /home/data/local/lib/postgresql/libMobilityDB.so | grep setpoint_linestring
LWGEOM_setpoint_linestring
LWGEOM_setpoint_linestring

select timespan('{[2000-01-01 08:00, 2000-01-01 08:20], [2000-01-01 08:30, 2000-01-01 08:40]}'::periodset);
-- 00:30:00
select timespan('{[1@2000-01-01 08:00, 5@2000-01-01 08:20], [5@2000-01-01 08:30, 1@2000-01-01 08:40]}'::tfloat);
-- 00:30:00

select temporalType('{[1@2000-01-01 08:00, 5@2000-01-01 08:20], [5@2000-01-01 08:30, 1@2000-01-01 08:40]}'::tfloat);
-- 'SequenceSet'

select duration('{[2000-01-01 08:00, 2000-01-01 08:20], [2000-01-01 08:30, 2000-01-01 08:40]}'::periodset);
-- 00:30:00
select duration('{[1@2000-01-01 08:00, 5@2000-01-01 08:20], [5@2000-01-01 08:30, 1@2000-01-01 08:40]}'::tfloat);
-- 00:30:00

select timespan('{[2000-01-01 08:00, 2000-01-01 08:20], [2000-01-01 08:30, 2000-01-01 08:40]}'::periodset);
-- 00:40:00
select timespan('{[1@2000-01-01 08:00, 5@2000-01-01 08:20], [5@2000-01-01 08:30, 1@2000-01-01 08:40]}'::tfloat);
-- 00:40:00

Temporal Duration	Name	Base Type Specific Examples
Temporal	temporal	tint, tgeompoint
Instant	temporalinst	tintinst, tgeompointinst
Instant Set	temporali	tinti, tgeompointi
Sequence	temporalseq	tintseq, tgeompointseq
Sequence Set	temporals	tints, tgeompoints

Temporal Duration	Class Name	Base Type Specific Examples
Temporal	Temporal	TInt, TGeomPoint
Instant	TemporalInst	TIntInst, TGeomPointInst
Instant Set	TemporalI	TIntI, TGeomPointI
Sequence	TemporalSeq	TIntSeq, TGeomPointSeq
Sequence Set	TemporalS	TIntS, TGeomPointS

Temporal Duration	Class Name	Base Type Specific Examples
Temporal	Temporal	Temporal<int>, Temporal<Geometry>
Instant	TInstant	TInstant<int>, TInstant<Geometry>
Instant Set	TInstantSet	TInstantSet<int>, TInstantSet<Geometry>
Sequence	TSequence	TSequence<int>, TSequence<Geometry>
Sequence Set	TSequenceSet	TSequenceSet<int>, TSequenceSet<Geometry>

Temporal Duration	Class Name	Base Type Specific Examples
Temporal	Temporal	TemporalInt, TemporalGeom
Instant	TInstant	TInstantInt, TInstantGeom
Instant Set	TInstantSet	TInstantSetInt, TInstantSetGeom
Sequence	TSequence	TSequenceInt, TSequenceGeom
Sequence Set	TSequenceSet	TSequenceSetInt, TSequenceSetGeom

mobilitydb / mobilitydb Goto Github PK

mobilitydb's Introduction

MobilityDB

Documentation

Benefits

Experimental Projects

Cloud

Visualization

Public Transport

Mailing Lists

Branches

Requirements

Building & Installation

Docker Container

Issues

Generating the Documentation

User's Manual

Developer's Documentation

Licenses

mobilitydb's People

Contributors

Stargazers

Watchers

Forkers

mobilitydb's Issues

Overview

Approach 1

Approach 2

Comparision

Conclusion

Overview

Recommend Projects

Recommend Topics

Recommend Org