Type-Safe Casting Functions ​

The following SQL functions are supported for compatibility with applications developed in other databases. These functions implement type-safe casting from VARCHAR strings to DATE, TIMESTAMP, and DOUBLE data types.

Note: These functions are disabled by default. To enable them system-wide, run the following commands:

yellowbrick=# alter system set enable_safe_compat_functions_with_nz to true;
WARNING:  Will be effective after the next server configuration reload, or after the next server restart in the case of parameters that can only be changed at server start
ALTER SYSTEM
yellowbrick=# select pg_reload_conf();
 pg_reload_conf 
----------------
 t
(1 row)

In This Section

• SAFE_TO_DATE

• SAFE_TO_DOUBLE

• SAFE_TO_TIMESTAMP

Parent topic:SQL Functions and Operators