Top

9.34.8. Using Geometries in Client Applications and SQL Procedures

In SQL procedures, a geometry is a member of the ANY data type. The isgeometry () function can be used for testing if an object is a geometry. A geometry can only be stored in a column declared to be of type ANY.

If a geometry would be returned to a client application as part of a result set, it is returned as a string containing its WKT text representation. For a client application to pass geometries to the server, it must pass these either as a WKT string parameter to st_geomfromtext or as numeric coordinate values for st_point or related functions. This applies to all clients, ODBC, JDBC, .net and any RDF frameworks.

[Tip] See Also:

RDF and Geometry