All Products
Search
Document Center

PolarDB:ST_IsExternal

Last Updated:Mar 28, 2026

Checks whether a trajectory object's data is stored in Object Storage Service (OSS).

This function is not supported in later versions. Use Cold data tiered storage instead.

Syntax

bool ST_IsExternal(trajectory traj);

Parameters

ParameterDescription
trajThe trajectory object to check.

Description

Returns t if the trajectory object's data is stored in OSS, or f otherwise.

Examples

The following example checks whether each trajectory in the trajs table is stored in OSS.

SELECT ST_IsExternal(traj) FROM trajs;

Output:

 st_isexternal
---------------
 t
 t
 t
 f
 t
(5 rows)