Returns a GEOMETRY object that has its SRID (spatial reference system identifier) set to the specified value.
Use this function to change the SRID without affecting the coordinates of the object. If you also need to change the coordinates to match the new SRS (spatial reference system), use ST_TRANSFORM instead.
Syntax¶ST_SETSRID( <geometry_expression> , <srid> )
Copy
Arguments¶geometry_expression
The argument must be an expression of type GEOMETRY.
srid
The SRID to set in the returned GEOMETRY object.
The function returns a value of type GEOMETRY.
Usage notes¶ Examples¶The following example creates and returns a GEOMETRY object that uses the SRID 4326:
ALTER SESSION SET GEOMETRY_OUTPUT_FORMAT='EWKT'; SELECT ST_SETSRID(TO_GEOMETRY('POINT(13 51)'), 4326); +-----------------------------------------------+ | ST_SETSRID(TO_GEOMETRY('POINT(13 51)'), 4326) | |-----------------------------------------------| | SRID=4326;POINT(13 51) | +-----------------------------------------------+Copy
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4