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)