15.10 - GetUserFld - Teradata Database

Teradata Database SQL Geospatial Types

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1181-151K

Returns the user field specified by fldIndex for the point specified by index for a GeoSequence type.

 

Argument …

Specifies …

fldIndex

the index of the user field within the point, where the index of the first user field is 1.

The data type of fldIndex is INTEGER.

index

the index of the point within the GeoSequence type, where the index of the first point is 1.

The data type of index is INTEGER.

Returns a FLOAT value.

GeoSequence

CREATE TABLE sample_shapes(skey INTEGER, shape ST_Geometry);
 
INSERT INTO sample_shapes ( 100,'GeoSequence( (10 10, 15 15, -2 0) ,(2007-03-14 01:35:00, 2007-03-14 01:35:05, 2007-03-14 01:35:08),(1222, 1223, 1224),(2, 12.1, 3.14159, 2.78128, -10, -11, 100.1))' );
 
   SELECT skey
   FROM sample_shapes
   WHERE (shape.GetUserFld(1,2) < 1E2)
   ORDER BY skey;