{ [TD_SYSFNLIB.] GeoJSONFromGeom ( geom_expr [, precision] ) |
( [TD_SYSFNLIB.] GeoJSONFromGeom ( geom_expr [, precision] ) RETURNS returns_clause )
}
Syntax Elements
-
returns_clause
-
{ data_type [ ( integer ) ] [ CHARACTER SET { UNICODE | LATIN } ] |
STYLE column_expr
}
- TD_SYSFNLIB
- The name of the database where the function is located.
-
geom_expr
- An expression which evaluates to an ST_Geometry object that represents a Point, MultiPoint, LineString, MultiLineString, Polygon, MultiPolygon, or GeometryCollection.
-
precision
- An integer specifying the maximum number of decimal places in the coordinate values.
- If this argument is NULL or not specified, the default precision is 15.
- RETURNS data_type
- Specifies that data_type is the return type of the function.
-
data_type can be VARCHAR, CLOB, or JSON.
-
integer
- Specifies the maximum length of the return type.
- If you do not specify a maximum length, the default is the maximum length supported by the return data type.
- CHARACTER SET
- The character set for the return value of the function, which can be LATIN or UNICODE.
- If you do not specify a character set, the default character set for the user is used.
- RETURNS STYLE column_expr
- Specifies that the return type of the function is the same as the data type of the specified column. The data type of the column must be VARCHAR, CLOB, or JSON.
-
column_expr can be any valid table or view column reference.