Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.snowflake.com/en/sql-reference/functions/try_to_geography below:

TRY_TO_GEOGRAPHY | Snowflake Documentation

Categories:

Geospatial functions, Conversion functions

Parses an input and returns a value of type GEOGRAPHY.

This function is identical to TO_GEOGRAPHY except that it returns NULL when TO_GEOGRAPHY would return an error.

See also:

TO_GEOGRAPHY

Use one of the following:

TRY_TO_GEOGRAPHY( <varchar_expression> [ , <allow_invalid> ] )

TRY_TO_GEOGRAPHY( <binary_expression> [ , <allow_invalid> ] )

TRY_TO_GEOGRAPHY( <variant_expression> [ , <allow_invalid> ] )

Copy

Required:

varchar_expression

The argument must be a string expression that represents a valid geometric object in one of the following formats:

• WKT (well-known text).

• WKB (well-known binary) in hexadecimal format (without a leading 0x).

• EWKT (extended well-known text).

• EWKB (extended well-known binary) in hexadecimal format (without a leading 0x).

• GeoJSON.

binary_expression

The argument must be a binary expression in WKB or EWKB format.

variant_expression

The argument must be an OBJECT in GeoJSON format.

Optional:

allow_invalid

If TRUE, specifies that the function should return a GEOGRAPHY or GEOMETRY object, even when the input shape is invalid and cannot be repaired. For details, refer to Specifying how invalid geospatial shapes are handled.

The function returns a value of type GEOGRAPHY.

• Returns NULL if the input cannot be parsed as the appropriate supported format (WKT, WKB, EWKT, EWKB, GeoJSON).

• Returns NULL if the input format is EWKT or EWKB and the SRID is not 4326. See the note on EWKT and EWKB handling.

• For the coordinates in WKT, EWKT, and GeoJSON, longitude appears before latitude (for example, POINT(lon lat)).

This shows a simple use of the TRY_TO_GEOGRAPHY function with VARCHAR data:

select TRY_TO_GEOGRAPHY('Not a valid input for this data type.');
+-----------------------------------------------------------+
| TRY_TO_GEOGRAPHY('NOT A VALID INPUT FOR THIS DATA TYPE.') |
|-----------------------------------------------------------|
| NULL                                                      |
+-----------------------------------------------------------+

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